UnitySync ODBC configuration for LinuxCreated: 2022-08-21 15:04:23
Modified: 2022-08-21 15:06:01
Tags: ODBC UnitySync
UnitySync ODBC configuration for Linux
UnitySync uses unixODBC as it’s method to access external databases.
Please use your distribution’s package manager (or vendor download) to install the necessary ODBC drivers. You can optionally install the unixODBC driver manager to aid in your configuration of ODBC connections. We will be using a manual configuration in this example.
The ODBC configuration is broken down into 2 files. Once these files are configured, they should show up in UnitySync as an available System DSN. Please refer to your ODBC drivers' documentation for implementation specific configuration items.
This file defines your actual drivers available for your ODBC connections. The following is an example of configuring a MySQL driver (your configuration may vary)
[MySQL] Description= Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so Driver64= Setup= Setup64= UsageCount=1 CPTimeout= CPReuse=
This file defines a system DSN available to UnitySync. The following example uses the driver definition above and some specifics about the database we will be connecting to
[Company Directory] Description=Acme Directory Driver=MySQL Server=sql.acme.com Database=directory_db Port= Socket= Option= Stmt= Charset=UTF8