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: Updating the DynamicSections Parameter of a DB2 Database

Installation for Data Engineering

Installation for Data Engineering

Sample odbc.ini File

Sample odbc.ini File

The following sample shows the entries for the ODBC drivers in the ODBC.ini file:
[ODBC Data Sources] SQL Server Legacy Wire Protocol=DataDirect 7.1 SQL Server Legacy Wire Protocol DB2 Wire Protocol=DataDirect 7.1 DB2 Wire Protocol Informix Wire Protocol=DataDirect 7.1 Informix Wire Protocol Oracle Wire Protocol=DataDirect 8.0 Oracle Wire Protocol Sybase Wire Protocol=DataDirect 7.1 Sybase Wire Protocol SQL Server Wire Protocol=DataDirect 8.0 SQL Server Wire Protocol MySQL Wire Protocol=DataDirect 7.1 MySQL Wire Protocol PostgreSQL Wire Protocol=DataDirect 7.1 PostgreSQL Wire Protocol Greenplum Wire Protocol=DataDirect 7.1 Greenplum Wire Protocol [ODBC] IANAAppCodePage=4 InstallDir=/<Informatica installation directory>/ODBC7.1 Trace=0 TraceFile=odbctrace.out TraceDll=/<Informatica installation directory>/ODBC7.1/lib/DWtrc27.so [DB2 Wire Protocol] Driver=/<Informatica installation directory>/ODBC7.1/lib/DWdb227.so Description=DataDirect 7.1 DB2 Wire Protocol AccountingInfo= AddStringToCreateTable= AlternateID= AlternateServers= ApplicationName= ApplicationUsingThreads=1 AuthenticationMethod=0 BulkBinaryThreshold=32 BulkCharacterThreshold=-1 BulkLoadBatchSize=1024 BulkLoadFieldDelimiter= BulkLoadRecordDelimiter= CatalogSchema= CharsetFor65535=0 ClientHostName= ClientUser= #Collection applies to z/OS and iSeries only Collection= ConcurrentAccessResolution=0 ConnectionReset=0 ConnectionRetryCount=0 ConnectionRetryDelay=3 CurrentFuncPath= #Database applies to DB2 UDB only Database=<database_name> DefaultIsolationLevel=1 DynamicSections=1000 EnableBulkLoad=0 EncryptionMethod=0 FailoverGranularity=0 FailoverMode=0 FailoverPreconnect=0 GrantAuthid=PUBLIC GrantExecute=1 GSSClient=native HostNameInCertificate= IpAddress=<DB2_server_host> KeyPassword= KeyStore= KeyStorePassword= LoadBalanceTimeout=0 LoadBalancing=0 #Location applies to z/OS and iSeries only Location=<location_name> LogonID= MaxPoolSize=100 MinPoolSize=0 Password= PackageCollection=NULLID PackageNamePrefix=DD PackageOwner= Pooling=0 ProgramID= QueryTimeout=0 ReportCodePageConversionErrors=0 TcpPort=50000 TrustStore= TrustStorePassword= UseCurrentSchema=0 ValidateServerCertificate=1 WithHold=1 XMLDescribeType=-10 [Informix Wire Protocol] Driver=/<Informatica installation directory>/ODBC7.1/lib/DWifcl27.so Description=DataDirect 7.1 Informix Wire Protocol AlternateServers= ApplicationUsingThreads=1 CancelDetectInterval=0 ConnectionRetryCount=0 ConnectionRetryDelay=3 Database=<database_name> HostName=<Informix_host> LoadBalancing=0 LogonID= Password= PortNumber=<Informix_server_port> ServerName=<Informix_server> TrimBlankFromIndexName=1 UseDelimitedIdentifiers=0 [Oracle Wire Protocol] Driver=/<Informatica installation directory>/ODBC7.1/lib/DWora28.so Description=DataDirect 8.0 Oracle Wire Protocol AlternateServers= ApplicationUsingThreads=1 AccountingInfo= Action= ApplicationName= ArraySize=60000 AuthenticationMethod=1 BulkBinaryThreshold=32 BulkCharacterThreshold=-1 BulkLoadBatchSize=1024 BulkLoadFieldDelimiter= BulkLoadRecordDelimiter= CachedCursorLimit=32 CachedDescLimit=0 CatalogIncludesSynonyms=1 CatalogOptions=0 ClientHostName= ClientID= ClientUser= ConnectionReset=0 ConnectionRetryCount=0 ConnectionRetryDelay=3 DataIntegrityLevel=0 DataIntegrityTypes=MD5,SHA1 DefaultLongDataBuffLen=1024 DescribeAtPrepare=0 EditionName= EnableBulkLoad=0 EnableDescribeParam=0 EnableNcharSupport=0 EnableScrollableCursors=1 EnableStaticCursorsForLongData=0 EnableTimestampWithTimeZone=0 EncryptionLevel=0 EncryptionMethod=0 EncryptionTypes=AES128,AES192,AES256,DES,3DES112,3DES168,RC4_40,RC4_56,RC4_128, RC4_256 FailoverGranularity=0 FailoverMode=0 FailoverPreconnect=0 FetchTSWTZasTimestamp=0 GSSClient=native HostName=<Oracle_server> HostNameInCertificate= InitializationString= KeyPassword= KeyStore= KeyStorePassword= LoadBalanceTimeout=0 LoadBalancing=0 LocalTimeZoneOffset= LockTimeOut=-1 LoginTimeout=15 LogonID= MaxPoolSize=100 MinPoolSize=0 Module= Password= Pooling=0 PortNumber=<Oracle_server_port> ProcedureRetResults=0 ProgramID= QueryTimeout=0 ReportCodePageConversionErrors=0 ReportRecycleBin=0 ServerName=<server_name in tnsnames.ora> ServerType=0 ServiceName= SID=<Oracle_System_Identifier> TimestampeEscapeMapping=0 TNSNamesFile=<tnsnames.ora_filename> TrustStore= TrustStorePassword= UseCurrentSchema=1 ValidateServerCertificate=1 WireProtocolMode=2 [Sybase Wire Protocol] Driver=/<Informatica installation directory>/ODBC7.1/lib/DWase27.so Description=DataDirect 7.1 Sybase Wire Protocol AlternateServers= ApplicationName= ApplicationUsingThreads=1 ArraySize=50 AuthenticationMethod=0 BulkBinaryThreshold=32 BulkCharacterThreshold=-1 BulkLoadBatchSize=1024 BulkLoadFieldDelimiter= BulkLoadRecordDelimiter= Charset= ConnectionReset=0 ConnectionRetryCount=0 ConnectionRetryDelay=3 CursorCacheSize=1 Database=<database_name> DefaultLongDataBuffLen=1024 EnableBulkLoad=0 EnableDescribeParam=0 EnableQuotedIdentifiers=0 EncryptionMethod=0 FailoverGranularity=0 FailoverMode=0 FailoverPreconnect=0 GSSClient=native HostNameInCertificate= InitializationString= Language= LoadBalancing=0 LoadBalanceTimeout=0 LoginTimeout=15 LogonID= MaxPoolSize=100 MinPoolSize=0 NetworkAddress=<Sybase_host,Sybase_server_port> OptimizePrepare=1 PacketSize=0 Password= Pooling=0 QueryTimeout=0 RaiseErrorPositionBehavior=0 ReportCodePageConversionErrors=0 SelectMethod=0 ServicePrincipalName= TruncateTimeTypeFractions=0 TrustStore= TrustStorePassword= ValidateServerCertificate=1 WorkStationID= [SQL Server Wire Protocol] Driver=/<Informatica installation directory>/ODBC7.1/lib/DWsqls28.so Description=DataDirect 8.0 SQL Server Wire Protocol AlternateServers= AlwaysReportTriggerResults=0 AnsiNPW=1 ApplicationName= ApplicationUsingThreads=1 AuthenticationMethod=1 BulkBinaryThreshold=32 BulkCharacterThreshold=-1 BulkLoadBatchSize=1024 BulkLoadOptions=2 ConnectionReset=0 ConnectionRetryCount=0 ConnectionRetryDelay=3 Database=<database_name> EnableBulkLoad=0 EnableQuotedIdentifiers=0 EncryptionMethod=0 FailoverGranularity=0 FailoverMode=0 FailoverPreconnect=0 FetchTSWTZasTimestamp=0 FetchTWFSasTime=1 GSSClient=native HostName=<SQL_Server_host> HostNameInCertificate= InitializationString= Language= LoadBalanceTimeout=0 LoadBalancing=0 LoginTimeout=15 LogonID= MaxPoolSize=100 MinPoolSize=0 PacketSize=-1 Password= Pooling=0 PortNumber=<SQL_Server_server_port> QueryTimeout=0 ReportCodePageConversionErrors=0 SnapshotSerializable=0 TrustStore= TrustStorePassword= ValidateServerCertificate=1 WorkStationID= XML Describe Type=-10 [MySQL Wire Protocol] Driver=/<Informatica installation directory>/ODBC7.1/lib/DWmysql27.so Description=DataDirect 7.1 MySQL Wire Protocol AlternateServers= ApplicationUsingThreads=1 ConnectionReset=0 ConnectionRetryCount=0 ConnectionRetryDelay=3 Database=<database_name> DefaultLongDataBuffLen=1024 EnableDescribeParam=0 EncryptionMethod=0 FailoverGranularity=0 FailoverMode=0 FailoverPreconnect=0 HostName=<MySQL_host> HostNameInCertificate= InteractiveClient=0 LicenseNotice=You must purchase commercially licensed MySQL database software or a MySQL Enterprise subscription in order to use the DataDirect Connect for ODBC for MySQL Enterprise driver with MySQL software. KeyStore= KeyStorePassword= LoadBalanceTimeout=0 LoadBalancing=0 LogonID= LoginTimeout=15 MaxPoolSize=100 MinPoolSize=0 Password= Pooling=0 PortNumber=<MySQL_server_port> QueryTimeout=0 ReportCodepageConversionErrors=0 TreatBinaryAsChar=0 TrustStore= TrustStorePassword= ValidateServerCertificate=1 [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=0 ExtendedColumnMetadata=0 FailoverGranularity=0 FailoverMode=0 FailoverPreconnect=0 FetchTSWTZasTimestamp=0 FetchTWFSasTime=0 HostName=<PostgreSQL_host> HostNameInCertificate= 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= TrustStorePassword= ValidateServerCertificate=1 XMLDescribeType=-10 [Greenplum Wire Protocol] Driver=/<Informatica installation directory>/ODBC7.1/lib/DWgplm27.so Description=DataDirect 7.1 Greenplum Wire Protocol AlternateServers= ApplicationUsingThreads=1 ConnectionReset=0 ConnectionRetryCount=0 ConnectionRetryDelay=3 Database=<database_name> DefaultLongDataBuffLen=2048 EnableDescribeParam=0 EnableKeysetCursors=0 EncryptionMethod=0 ExtendedColumnMetadata=0 FailoverGranularity=0 FailoverMode=0 FailoverPreconnect=0 FetchTSWTZasTimestamp=0 FetchTWFSasTime=0 HostName=<Greenplum_host> InitializationString= KeyPassword= KeysetCursorOptions=0 KeyStore= KeyStorePassword= LoadBalanceTimeout=0 LoadBalancing=0 LoginTimeout=15 LogonID= MaxPoolSize=100 MinPoolSize=0 Password= Pooling=0 PortNumber=<Greenplum_server_port> QueryTimeout=0 ReportCodepageConversionErrors=0 TransactionErrorBehavior=1 XMLDescribeType=-10
You might have to customize the DSN entries in the
ODBC.ini
file based on the third-party driver that you use. For more information about the DSN entries, see the corresponding third-party driver documentation.