If you are using the DataDirect Hive ODBC driver to integrate Unica Campaign with a big data source, you must configure the
driver after installing it.
Procedure
-
Modify the ODBC.ini file to specify the Hive server information, using the values shown in the
following example. Be sure to customize the items in bold to match your own
configuration.
-
Assuming that your ODBC driver is installed in the following location:
/opt/Progress/DataDirect/Connect64_for_ODBC_71
Make the following changes:
- Ensure that your LD_LIBRARY_PATH includes the following path:
=/opt/Progress/DataDirect/Connect64_for_ODBC_71/lib
- Ensure that your PATH includes the following path:
=/opt/Progress/DataDirect/Connect64_for_ODBC_71/tools
- Set your ODBCINI variable to point to the correct INI file. For example:
ODBCINI=/opt/Progress/DataDirect/Connect64_for_ODBC_71/odbc.ini ; export ODBCINI
- Set your ODBCINST variable to point to the correct INI file. For example:
ODBCINST=/opt/Progress/DataDirect/Connect64_for_ODBC_71/odbcinst.ini ; export ODBCINST
-
Verify the connectivity of the DataDirect ODBC driver and your Hive-based Hadoop big data
system:
cd /opt/Progress/DataDirect/Connect64_for_ODBC_71/samples/example
>> ./example
-
On the Unica Campaign
Analytical Server, set the ODBCINI and CAMPAIGN_HOME environment variables in
the Campaign/bin/setenv file. Run the Unica Campaign
odbctest utility to verify connectivity to Unica Campaign:
cd <Campaign_Home>/bin
>> ./odbctest