Problem with ODBC connection to MongoDB

[bl_jyskebank_dk]

I have a CosmosDB in Azure running MongoDB interface. I try to access it from our RedHat Linux server. I have opened a firewall port and I can telnet IP address and port in Azure from the server. Still I cannot make my ODBC connection through SAS Work. I use CDATA ODBC driver for MongoDB. It has the following odbc.ini:

[AZURE_MLU]
Driver=/opt/cdata/cdata-odbc-driver-for-mongodb/lib/libmongodbodbc.x64.so
Database=somedatabase
Password=somepassword
Port=10255
Server=someserver.documents.azure.com
User=someuser

Libname statement is:

LIBNAME mylib ODBC DATASRC=AZURE_MLU;

It returns an error:

ERROR: CLI error trying to establish connection: Unable to read the header of reply message response to 0.

ERROR: Error in the LIBNAME statement.

Any idea what this Means?

[JuanS_OCS]

Hello @bl_jyskebank_dk,

before any test of the ODBC connection from SAS, your DBAs or system admins must show you evidence they have configured the drivers, and the connections, and that they can connect to the db and query data, from the OS command line. Could they?

[bl_jyskebank_dk]

Thanks for your reply. I will ask them and get back to you.

[bl_jyskebank_dk]

Just tried from commandline. Same faulty answer:

sas@sf120lx00005:/etc$isql -v "CDATA_MongoDB_Source"

[08001][unixODBC]Unable to read the header of reply message response to 0.

[ISQL]ERROR: Could not SQLConnect

sas@sf120lx00005:/etc$

Asked the administrator (ODBC installer) to look into it.

[bl_jyskebank_dk · Accepted solution]

CDATA has just informed us that the MongoDB driver is not well suited for our purpose. They recommend the CosmosDB driver. It Works! We have now connected our virtual RedHat Linux driven SAS v9.4 to CosmosDB in Azure. We can browse data through a libname. We will now begin to test performance.