Configuring the ODBC DSN for MongoDB and Importing JSON File Metadata

 In this article we will see how connect MongoDB and import JSON File from MongoDB step by step.

Step #1:   The following ODBC DSN template can be used to connect to the MongoDB on UNIX platforms 

[MongoDBDSN] Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmongo00.so Description=DataDirect MongoDB ODBC Driver Wire Protocol Database=<database-name> LogonID= Password= HostName=<Server-IP> PortNumber=<Port-Number> QuotedId=No AnsiNPW=No SchemaDefinition=/tmp/mongo/mongodbtest.config CreateDB=2 ReadOnly=0 TransactionMode=1 ServerPortNumber=19931 SQLEngineMode=0

Step #2:   Starting the SQLEngine

The command to start the SQLEngine is:

/opt/IBM/InformationServer/jdk/jre/bin/java -Xmx1024m

-cp /opt/IBM/InformationServer/Server/branded_odbc/java/lib/mongodb.jar com.ddtek.mongodbcloud.sql.Server -port 19931

NOTE: You have to run the command with 'nohup .... &'

Step #3:   To create Schema Map we should run the script below

/data/IBM/InformationServer/jdk/jre/bin/java -jar /data/IBM/InformationServer/Server/branded_odbc/tools/schematool.jar

Step #4:   You will see 'Open shema Map' pop-up like below

Step #5:   To configure Schema Map we should create New Schema Map 

To connection MongoDB we need to define Host Name/PortNumber/ Authentication.

After choose '.config'  file and define all db connection parameters click 'Open Schema Map' 

You will see like below and then click 'Save'