Installation and configuration checklist

The following checklist enumerates all items that are specific to the configuration for PI SQL Client ODBC. This list is helpful if you are familiar with the standard configuration as provided in the Oracle document, Oracle Database Gateway Installation and Configuration Guide.

• Configure an ODBC DSN, select the Variant as String workaround and set the Maximum String Size value to 1333.

• Create an init<sid>.ora file that includes the following specific setting:

  HS_FDS_TIMESTAMP_MAPPING = TIMESTAMP

• Reference ODBC sid in listener.ora and tnsnames.ora (all standard, no specifics for PI SQL Client ODBC).

• Create the Database Link (all standard, no specifics for PI SQL Client ODBC).

• Enable the TO_NCHAR capability.

• Take special care when constraining string type columns.