ADO Configuration Example
The following scenario deals with the configuration of the ADO service to act as data gateway.
In this scenario, IDX acts as an ADO-SQL database gateway, interfacing a number of systems with the database. The data slots transporting data through the gateway are SLOT_1, SLOT_2, SLOT_3, SLOT_4 and SLOT_5. SLOT_1 and SLOT_2 are float values, read from the database. SLOT_3 is an integer value, written to the database, and SLOT_4 and SLOT_5 are BIT values, read from the database, but also written to by other interfaces, and thus written back to the database. Additional specifications include:
· A backup, mirrored database is available on a separate SQL Server platform. The IDX gateway must be configured to interact with both the primary and backup server so that if the primary server fails, the backup server is available to server database queries.
· The database, DBStore has been configured with an SQL database username of TestDB and password of !dxTest. A table named IDXTable will be the main data store.
· The database must be polled every 5 seconds.