Connect to MongoDB from the Schema Editor
Use the Schema Editor to connect to MongoDB through the ODBC connection.
Use one of the following options to connect to MongoDB from the Schema Editor when you want to define or edit the metadata:
- DSN List
- If you have created the DSN on Windows or Linux, the Schema Editor lists the DSN in the DSN list using the Informatica MongoDB 64-bit ODBC driver.
- The Schema Editor uses the following approach to use the DSN on Windows or Linux:
- - On Windows. When the Schema Editor prompts you to provide the connection information, select the DSN you created for MongoDB from the DSN list. The editor uses the specified DSN to connect to MongoDB.
- - On Linux. The Schema Editor searches for the odbc.ini file specified by the ODBCINI environment variable to read the DSN. If the ODBCINI environment variable is not available, the Schema Editor reads the DSN from the /etc/odbc.ini file.
- Connection String
- The Schema Editor recognises the following format of the connection string to connect to MongoDB:
Driver={Informatica MongoDB ODBC Driver 64-bit};Server={HOST_NAME};Port={27017};AuthMechanism={SCRAM-SHA-1};UID={USER_NAME};PWD={PASSWORD};Database={DATABASE};AuthSource={AUTH_DATABASE}
- The Schema Editor uses the following approach to use the connection string:
- - On Windows, the driver name in the connection string is the name of the MongoDB registry.
- - On Linux, the name of the driver is the name specified in the odbcinst.ini file for MongoDB.