Configuring the ODBC Driver on Windows
You must configure the Informatica MongoDB ODBC driver as an administrator before you can run MongoDB tasks or mappings. Configure the ODBC driver on a 64-bit Windows machine.
1. Place the mongodb_Win64.zip file in the following location on the Windows machine: C:\temp.
2. Unzip the mongodb_Win64.zip file.
The following directory appears: C:\temp\Win64
3. Copy the mongodb directory from C:\temp\Win64 and paste to the following directory: <Secure Agent installation directory>\drivers\odbc
4. Open the following file in a text editor C:\temp\Win64\MongoDBDriver64bit.reg, and perform the following tasks:
- a. Set the driver attribute to the following location: "Driver"="<Secure Agent installation directory>\\drivers\\odbc\\mongodb\\lib\\\MongoDBODBC_sb64.dll"
For example, if the Secure Agent is installed at C:\Program Files\Informatica Cloud Secure Agent, set the driver attribute to the following location: C:\\Program Files\\Informatica Cloud Secure Agent\\drivers\\odbc\\mongodb\\lib\\MongoDBODBC_sb64.dll
- b. Set the setup attribute to the following location: "Setup"="<Secure Agent installation directory\\drivers\\odbc\\mongodb\\lib\\MongoDBODBC_sb64.dll"
For example, if the Secure Agent is installed at C:\Program Files\Informatica Cloud Secure Agent, set the driver attribute to the following location: C:\\Program Files\\Informatica Cloud Secure Agent\\drivers\\odbc\\mongodb\\lib\\MongoDBODBC_sb64.dll
- c. Set the error messages path attribute to the following location: "ErrorMessagesPath"="<Secure Agent installation directory>>\\drivers\\odbc\\mongodb\\ErrorMessages"
For example, if the Secure Agent is installed at C:\\Program Files\\Informatica Cloud Secure Agent, set the attributes to the following directory: C:\\Program Files\\Informatica Cloud Secure Agent\\drivers\\odbc\\mongodb\\ErrorMessages
5. Double-click the following file to create the Informatica MongoDB registry: C:\temp\Win64\MongoDBDriver64bit.reg
6. Open the Registry Editor on the Windows machine and verify that the registry entries are set to the correct drivers.
7. Create the required 64-bit DSN for MongoDB using the Informatica MongoDB driver registry.