Alpha DevCon 2018

Data Integration with SQL and Database Sources

Comprehensive Back-End Data Access

At the heart of every business application is its data integration, and robust, secure data storage is essential. Whether your users are processing sales orders from the field, uploading geocoded images from a tablet, or updating critical business information on a local server, Alpha Anywhere ensures that your data connection is lightning fast on any device.

Store your data in a format that’s highly compatible. While Alpha Anywhere boasts its own built in database engine, it also integrates native drivers for virtually all major database back-ends including Microsoft SQL Server, Access, Excel, My SQL, Oracle, DB2, and many more. With Alpha Anywhere’s simple, intuitive builders, you’ll be up and running with your connection string in a matter of minutes regardless of the data schema you’re using.

SQL Databases and Setting Up Your Connection String

Use the Server-Side Language of Your Choice

Alpha Anywhere's web components simplify working with SQL databases. You can use the built-in SQL Genie, which automatically generates all of the code for CRUD operations, or you can edit the SQL statement directly. Alpha Anywhere gives you access to the server-side code at various levels, where you’ll be able to use the server-side language of your choice. Options include Alpha’s own Xbasic, C#, Javascript, VB.NET, or any .NET framework supported language.

Sophisticated Data Integration and Data Transformation

Easily connect to external environments including DLLs, OLE/ActiveX, .NET and web services, or your SQL database. With Alpha Anywhere, you can:

  • Execute standalone programs
  • Load DLLs and execute functions
  • Load and execute OLE/ActiveX components
  • Connect to various databases using Alpha’s own DAO or with ADO or ADO.Net
  • Load and execute .NET assemblies you or others have written
  • Connect to TCP/IP sockets, or even create a server
  • Access and execute remote web services

Read More: Alpha Anywhere and .NET Support
Read More: Customer Example of Web Service Integration
Read More: Alpha/.NET Features on Our Blog