Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Connecting to Databases from UNIX or Linux
  10. Appendix C: Connecting to Databases from Windows
  11. Appendix D: Updating the DynamicSections Parameter of a DB2 Database

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

Configuring ODBC Connectivity

Configuring ODBC Connectivity

You can configure ODBC connectivity to a PostgreSQL database on UNIX or Linux.
You can configure connectivity to PostgreSQL through ODBC using the DataDirect PostgreSQL Wire Protocol driver.
Review the following tasks for a guideline for configuring ODBC connectivity to PostgreSQL:
  1. Set the environment variable for PostgreSQL
  2. Configure ODBC connectivity in the ODBC.ini file
  3. Update the PowerCenter repository with the PostgreSQL data source name
  4. Verify the PostgreSQL connection with the ODBC data source
For specific instructions, see the database documentation.

Step 1. Set the Environment Variable

  1. In the Administrator tool, click
    Manage
    Services and Nodes
    .
  2. In the Domain Navigator, select the PowerCenter Repository Service.
  3. In the contents panel, click the Processes view. In the Environment Variables section, set the variable name as
    POSTGRES_ODBC
    and the value to
    1
    .

Step 2. Configure ODBC Connectivity

  1. Set the ODBCHOME environment variable to the ODBC installation directory. For example:
    Using a Bourne shell:
    $ ODBCHOME=<Informatica server home>/ODBC7.1; export ODBCHOME
    Using a C shell:
    $ setenv ODBCHOME <Informatica server home>/ODBC7.1
  2. Edit the existing odbc.ini file in the $ODBCHOME directory or copy the odbc.ini file to the UNIX home directory and edit it.
    $ cp $ODBCHOME/odbc.ini $HOME/.odbc.ini
  3. Open the odbc.ini file and add a entry for DataDirect PostgreSQL Wire Protocol data sources.
    Configure the data source name, driver path, host name, and port number to connect to the PostgreSQL database. For example:
    [PostgreSQL Wire Protocol] Driver=/<Informatica installation directory>/ODBC7.1/lib/DWpsql27.so Description=DataDirect 7.1 PostgreSQL Wire Protocol AlternateServers= ApplicationUsingThreads=1 ConnectionReset=0 ConnectionRetryCount=0 ConnectionRetryDelay=3 Database=<database_name> DefaultLongDataBuffLen=2048 EnableDescribeParam=1 EncryptionMethod=1 ExtendedColumnMetadata=0 FailoverGranularity=0 FailoverMode=0 FailoverPreconnect=0 FetchTSWTZasTimestamp=0 FetchTWFSasTime=0 GSSClient=native HostName=<PostgreSQL_host> HostNameInCertificate=<Host name in SSL certificate> InitializationString= KeyPassword= KeyStore= KeyStorePassword= LoadBalanceTimeout=0 LoadBalancing=0 LoginTimeout=15 LogonID= MaxPoolSize=100 MinPoolSize=0 Password= Pooling=0 PortNumber=<PostgreSQL_server_port> QueryTimeout=0 ReportCodepageConversionErrors=0 TransactionErrorBehavior=1 TrustStore=<Path of the truststore certificates> TrustStorePassword=<Password of the truststore certificates> ValidateServerCertificate=1 XMLDescribeType=-10
  4. Set the PATH environment variable.
    Using a Bourne shell:
    $ PATH=${PATH}:$ODBCHOME/bin; export PATH
    Using a C shell:
    $ setenv PATH ${PATH}:$ODBCHOME/bin
  5. Set the shared library environment variable based on the operating system.
    The following table describes the shared library variables for each operating system:
    For example, use the following syntax to set the LD_LIBRARY_PATH for Linux:
    • Using a Bourne shell:
      $ LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$HOME/server_dir :$ODBCHOME/lib; export LD_LIBRARY_PATH
    • Using a C shell:
      $ setenv LD_LIBRARY_PATH $HOME/server_dir:$ODBCHOME/lib:${LD_LIBRARY_PATH}
    For example, use the following syntax to set the LIBPATH for AIX:
    • Using a Bourne shell:
      $ LIBPATH=${LIBPATH}:$HOME/server_dir :$ODBCHOME/lib; export LIBPATH
    • Using a C shell:
      $ setenv LIBPATH ${LIBPATH}:$HOME/server_dir :$ODBCHOME/lib

Step 3. Update the PowerCenter Repository Database Properties

  1. Select the PowerCenter Repository Service in the Administrator tool.
  2. In the database properties section, enter the same data source name that you specified for PostgreSQL in the ODBC.ini file.
  3. Save your changes.

Step 4. Verify PostgreSQL Connection

  1. Verify that you can connect to the PostgreSQL database using the ODBC data source.
  2. If the connection fails, see the database documentation.

0 COMMENTS

We’d like to hear from you!