AdessoSQL is the add-on that Adesso uses to interact with other data sources. A data source is a source of data and the connection information needed to access that data. Examples of data sources are Microsoft Access, Microsoft SQL Server, Oracle RDBMS, a spreadsheet, and a text file. Examples of connection information include server location, database name, login ID, password, and various ODBC driver options that describe how to connect to the data source.
In the ODBC architecture, an application, such as Microsoft Access or SQL, connects to the ODBC Driver Manager, which in turn uses a specific ODBC driver (for example, Adesso SQL) to connect to a data source (in this case, the Adesso Server).
Adesso SQL Features
 |
ODBC Driver
ODBC is a standard for accessing data from data sources. Using our ODBC driver along with the Adesso Platform is a very powerful combination. You can now move your data from back end data systems, through the Adesso Server, to your mobile end users. You can also gather information that is collected by your mobile end users and integrate it with your back end systems. |
 |
Application Interfaces
Adesso can easily interface with open application programming interfaces (APIs) such as Google Maps. This means that, for example, you can collect GPS readings on a Pocket PC, and in near real time, you can display the locations of those GPS readings on a Google Maps interface. |
 |
Web Services
The Adesso Server can communicate with other databases and Internet technologies through the use of web services. A dynamic, password-protected website can be created to query and display the records in specific tables within each of the databases. |
