UnitySync ODBC configuration for Linux

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.

/etc/odbcinst.ini

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=

/etc/odbc.ini

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