Others

If you have any other sources for which you have an ODBC driver installed, you can extract data from them by defining the relevant connection and query settings.

Note: As such connections have not been tested with the Gateway, you may not be able to resolve any issues related to these sources.

The following is a screenshot of the Other data sources under Extract.

• Data Name: Specify the extracted data name that is used to generate the name of the output EIWM file, CSV file and logs.

• Connection Retry Time: Specify the time that the Gateway waits to retry connecting to the data source.

• Connection String: Type the code to connect to the data source supported by ODBC.

• Query: Specify the SQL query that will be used to extract data from the data source.

  Notes:

  • If the other data source is pointing to a database system, it is recommended to restrict the database user account with the read-only access to the databases (or the selected tables/views) from which information needs to be extracted. It is required to avoid accidental addition, change or deletion of sensitive data.

  • If the database supports SSL encryption then in order to ensure the security of data which is in transit between the Gateway and the database, you can configure an SSL-encrypted connection between the two.