Here are the steps to start All Services in IBM InfoSphere Information Server on Windows Step 01 : Start the WebSphere …
How to connect to MongoDB from DataStage using ODBC
Here are the steps to connect to the MongoDB database from DataStage using the ODBC connector. These steps were tested on a DataStage server running on Windows. You need to have your
Mongo DB Server
MongoDB mongod process up and running. mongod is the primary daemon process for the MongoDB system. It handles data requests, manages data access, and performs background management operations
MongoDB BI Connector mongosqld process up and running. mongosqld accepts incoming requests from a SQL client and proxies those requests to a mongod. mongosqld needs to start with the addr option if you need mongosqld to wait for connection at multiple addresses
"mongosqld.exe" --addr "192.168.40.1,localhost"
These are the prerequisites and will be taken care by your MongoDB admin.
Below mentioned steps need to be followed for DataStage server configuration
Step 01: Download and install the “MongoDB ODBC Driver for BI Connector” from https://github.com/mongodb/mongo-odbc-driver/releases/. As of today September 29, 2018 MongoDB ODBC driver is available for Windows, Ubuntu 14.04, Ubuntu 16.04 and RHEL 7 DataStage server platform. Choose the correct version\bit for your operating system
Step 02: Create an ODBC connection. This ODBC entry needs to be added in system DSN (Image 02) and the driver should be Unicode Driver (Image 03). For LINUX\AIX environments ODBC connection entry needs to be created in odbc.ini.
Step 03: Test the ODBC connection from Windows and make sure it’s working.
Step 04: Edit the “uvodbc” of your project to add the entry at the bottom for this newly created ODBC connection.This is applicable for DataStage servers running on Windows only. Here is how this entry will look like
DBMSTYPE = ODBC
Step 05: Test the ODBC connection from DataStage and make sure its working by trying a table definition import. If the connection is successful you will be able to see the table definition (Image 03)
Step 06: Create the DataStage job with ODBC stage to connect to the MongoDB and run the same. I had to disable the AUTOCOMMIT in the ODBC stage for the job to run fine
Step 07: Validate the results as applicable
Hope this is helpful information to make a MongoDB connection from DataStage.
This is a utility to scan the DataStage job run logs to find the usage of a given table OR file. We can find where a …