How to: |
This tutorial guides you through the steps that you need to configure the DataDirect ODBC driver for Hyperstage. You must complete the following steps to successfully configure the driver.
The Reporting Server can only have one Hyperstage (PG) Adapter installed at a time. If Hyperstage (PG) JDBC Adapter or Hyperstage (PG) ODBC PostgreSQL is configured, it must be removed before the ODBC driver can be configured.
The following procedure walks you through a sample configuration for the DataDirect ODBC driver.
The WinZip Self-Extractor dialog box opens.
The data_direct.ps1 and data_direct.bat files are created in the directory.
The existing Hyperstage (PG) Adapter is shown in the folder, as shown in the following image.
The ODBC DataDirect option is available, as shown in the following image.
Note: This option is only available if an existing Hyperstage (PG) adapter is removed from your configuration.
The Add Hyperstage (PG) ODBC DataDirect to Configuration dialog box opens.
A confirmation message opens, indicating that the adapter was successfully added to the configuration.
The Edit Profile window opens.
SQL SQLHYPG SET DD_LICENSE_FILE DDW_.LIC SQL SQLHYPG SET DD_LICENSE_PASSWORD {AES}FEB21C1C3A1164A4E6DEAC05685725C2F4242AE14BE238623C6052E12E340A84
Note: This text is also found in the Sample_edasprof_with_DataDirect_ODBC_Settings.txt file that is packaged in the Hyperstage_datadirect.zip folder.
An example of the Edit Profile window with this text is shown in the following image.
The Hyperstage PG Adapter Test Successful window opens, as shown in the following image.
The DataDirect ODBC driver is ready to be used to retrieve large volumes of data.
WebFOCUS | |
Feedback |