Sumário

Search

  1. Prefácio
  2. Parte   1: Guia de introdução à instalação
  3. Parte   2: Antes de Instalar os Serviços
  4. Parte   3: Executar instalador de serviços
  5. Parte   4: Após instalar os serviços
  6. Parte   5: Instalação do Cliente Informatica
  7. Parte   6: Desinstalação
  8. Apêndice A: Iniciando e Interrompendo Serviços Informatica
  9. Apêndice B: Gerenciando pacotes de distribuição
  10. Apêndice C: Conectando-se a bancos de dados do UNIX ou Linux
  11. Apêndice D: Conectando-se com Bancos de Dados no Windows
  12. Apêndice E: Atualizando o Parâmetro DynamicSections de um Banco de Dados DB2

Instalação para PowerCenter e Data Quality

Instalação para PowerCenter e Data Quality

Exemplo do Arquivo odbc.ini

Exemplo do Arquivo odbc.ini

O seguinte exemplo mostra as entradas para os drivers ODBC no arquivo ODBC.ini:
[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=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 [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
Talvez seja preciso personalizar as entradas DSN no arquivo
ODBC.ini
com base no driver de terceiros que você utilizar. Para obter mais informações sobre as entradas DSN, consulte a documentação do driver de terceiros correspondente.