MongoDB Connector Guide > MongoDB ODBC Driver Configuration > Configuring the ODBC Driver on Linux
  

Configuring the ODBC Driver on Linux

You must configure the Informatica MongoDB ODBC driver with details of the MongoDB database and the ODBC driver manager before you can run the MongoDB tasks or mappings. Configure the ODBC driver on a 32-bit or 64-bit Linux machine and add entries for the MongoDB data source in the odbc.ini file.
    1. Place the MongoDB<x>bit_linux.zip file in the following location on the Linux machine: ~/temp/ directory
    2. Unzip the following file: MongoDB<XX>bit_linux.zip
    3. Copy ~/temp/Linux<XX>/mongodb to the following directory: <Secure_Agent_Installation_Directory>/main/drivers/odbc
    4. Update the following paths in the <Secure_Agent_Installation_Directory>/main/drivers/odbc/mongodb/lib/informatica.mongodbodbc.ini configuration file:
    5. Provide the execute permissions to the files in the following directory: chmod +x -R <INFA_AGENT_HOME>/main/drivers/odbc/mongodb/
    6. Add entries for the MongoDB data sources in the odbc.ini file.
    The following section shows a sample entry in the odbc.ini file:
    [Sample_MongoDB_ODBC_DSN]
    Driver=<INFA_AGENT_HOME>/main/drivers/odbc/mongodb/lib/libinformaticamongodbodbc<XX>.so
    Host=[Host]
    Port=[Post]
    Database=[Database]
    DefaultStringColumnLength=255
    RowsFetchedPerBlock=4096
    CacheMetadata=1
    EnableAuthentication=0
    UseSqlWVarchar=1
    UseJsonColumn=0
    NestedColumnSeparator=_
    VTKeyColumnSeparator=_
    UpdateMultipleRows=1
    OmitColumns=1
    7. Set the ODBCINI environment variable on the Linux machine to the location of the odbc.ini file in which you created the data source name.
    To set the ODBCINI environment variable, you can choose to export the ODBCINI variable. For example, run the following script from the Linux machine: export ODBCINI=<Secure_Agent Installation_Directory>/main/odbc.ini
    8. Restart the Secure Agent.