topic Problem with ODBC connection to MongoDB in Microsoft Integration with SAS

Problem with ODBC connection to MongoDB

bl_jyskebank_dk — Mon, 16 Jul 2018 13:16:26 GMT

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?

Re: Problem with ODBC connection to MongoDB

JuanS_OCS — Tue, 17 Jul 2018 08:58:15 GMT

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?

Re: Problem with ODBC connection to MongoDB

bl_jyskebank_dk — Tue, 17 Jul 2018 09:01:38 GMT

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

Re: Problem with ODBC connection to MongoDB

bl_jyskebank_dk — Tue, 17 Jul 2018 11:12:12 GMT

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.

Re: Problem with ODBC connection to MongoDB

bl_jyskebank_dk — Wed, 18 Jul 2018 06:30:57 GMT

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.