The ODBC driver must be installed on the machine where the agent is installed. Follow the instructions of the manufacturer of the ODBC driver used for the installation and the configuration of the driver on Windows. Afterwards, specify the correct connection string to the driver in the RayVentory Data Hub task. How the final connection string will look depends on the driver that is installed.
|
Be aware: The query that is to be executed on the target database has to be written in a syntax that is understood by the database. If the target database only understands MySQL, it must be written in the MySQL syntax. |
Examples on how to configure the ODBC Connector for the connection with an OracleDB using an ODBC Oracle Instance Client Driver can be found in the Administration and User Guide under Data Hub > Guides and How-Tos > Connecting to OracleDB with ODBC Connector.