Features: Data Connectivity



Comprehensive Back-End Database Support


At the heart of every business application is its data, and robust, secure data connectivity 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 back-end technology you’re using.

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 Integration of Other Technologies in a Web Environment


Easily connect to external environments including DLLs, OLE/ActiveX, .NET and web services, and SQL databases. 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