Installing CData Virtuality ODBC (macOS)

Installing iODBC

Before installing the CData Virtuality ODBC, please Install the latest stable version of iODBC from iODBC Downloads.

Installing CData Virtuality ODBC Driver

1. Download the DataVirtualityODBCforMacOS.zip file from the CData Virtuality web interface.
2. Unzip the archive.
3. Copy the 'DataVirtualityODBC' folder to /Library/ODBC/ODBCDataSources.
4. Install the driver in /Library/ODBC/odbcinst.ini by adding the following:

[ODBC Drivers]
DataVirtuality Unicode(x64) = Installed

[DataVirtuality Unicode(x64)]
Driver = /Library/ODBC/ODBCDataSources/DataVirtualityODBC/dvodbcw.so

Configuration

Creating DSN via the odbc.ini file

Create a DSN by editing /Library/ODBC/odbc.ini. Add the following snippet and adapt values as needed:

[ODBC Data Sources]
dvodbc = Data Virtuality ODBC Driver


[dvodbc]
Driver = /Library/ODBC/ODBCDataSources/DataVirtualityODBC/dvodbcw.so
database = datavirtuality
servername = <ip or hostname>
port = 35432
username = <your username>
password = <your password>

For SSL, the default port is 35433, and the sslMode parameter needs to be added and set to something different from 'disabled' (allow, prefer, required, ...).