PowerExchange for MongoDB User Guide

PowerExchange for MongoDB User Guide

Configuring the Informatica MongoDB ODBC Driver on Linux

Configuring the Informatica MongoDB ODBC Driver on Linux

You must configure the Informatica MongoDB ODBC driver with details of the MongoDB database and ODBC driver manager before you can run MongoDB
mappings
.
Edit the
odbc.ini
file to configure the driver in the following location:
<INFA_HOME>/tools/mongodb/Setup
  1. Enter the correct ODBCInstLib for the ODBC Driver Manager in all the .ini files.
  2. Replace <INSTALL_DIR> with the path to the Informatica services installation directory in all the .ini files.
  3. Add the following information to the LD_LIBRARY_PATH environment variable:
    • <INFA_HOME>/tools/mongodb/lib
    • 64-bit
      library directory of the ODBC Driver Manager
  4. Add the path of the odbc.ini file to the ODBCINI environment variable.
  5. Add entries for all the MongoDB data sources in the
    odbc.ini
    file.
    The following section shows a sample entry in the
    odbc.ini
    file:
    [Sample Informatica MongoDB DSN] Description=Informatica MongoDB ODBC Driver DSN Driver=]<INFA_HOME>/tools/mongodbodbc/lib/libinformaticamongodbodbc64.so Host=[Host] Port=[Port] Database=[Database] ReadPreference=primary ReplicaSetName="" SecondaryServers="" UseReplicaSet=0 VirtualTableDetection=0 VTAnyMatchColumnsDetection=0 VTAnyMatchString=ANY VTAnyMatchTableNameSuffix=any VTArrayCountPrefix=Number of VTHideRealTables=0 VTIndexColSuffix=index VTInsertUpdateSafeMode=0 VTKeyColumnSeparator=. VTMainTableNameSeparator=main VTMainTableShowArrayCounts=0 VTTableNameSeparator=_vt_ DefaultBinaryColumnLength=32767 DefaultContainerColumnLength=511 DefaultJSONColumnLength=1023 DefaultStringColumnLength=255 CheckGetLastError=1 OmitColumns=1 TruncateDocument=0 UpdateMultipleRows=1 NestedColumnSeparator=__ SchemaDetectRealColumnsMax=10000 SchemaDetectSampleSize=100 SchemaDetectSampleStrategy=End SchemaDetectShowContainerColumns=0 ArrayColumnMax=5 AuthenticationDatabase= CacheMetadata=1 ExportMetadataToFile= ExportSchemaMapTo= ExtendedJSON=0 ImportSchemaMapFrom= LocalMetadataFile= ResetFileFromMetadata= RowsFetchedPerBlock=4096 UpsertOnUpdate=0 UseJsonColumn=0

0 COMMENTS

We’d like to hear from you!