Synchronization with Remote Databases
InfoQube can pull data from external data sources, such as SQL Server, mySQL, Oracle, MSAccess, etc. Any ODBC data source can be used.
When configured correctly, a click of a button is all that is required to refresh the data!
This is an advanced feature which requires some database query knowledge to configure it correctly.
The sync is done through a configuration file (xml type). This file defines:
- The connection string
- The SQL statement to retrieve the data (use Access, Enterprise Manager or other similar tool to generate the statement)
- The field mapping between the back-end database and InfoQube ( back-end fields are [ ] enclosed, otherwise a fixed value will be imported)
- The synchronization parameters. (Unique record identifier field, Last update date, etc)