Connect to Azure Cosmos DB with SQL API

[nmilleson]

Curious if anybody has attempted a connection to an Azure Cosmos database that is stood up with the SQL API.  We are fairly certain that we'll need to create an extension, but if anybody has any experience with it, any advice would be greatly appreciated.  Thanks!

[CRArko]

Hello.

I don't find much in the documentation or the Knowledgebase or known cases about anyone connecting to the Azure Cosmos DB with ThingWorx. This leads me to believe this connection is not currently supported. That may change in the future.

Along with you, I would also love to hear from the community at large if this connection has been tried and what the results were.

Thanks,

-- Craig A.

[Etienne]

Almost the same problem here, but with Gremlin API !

I created an extension with the marketplace's "JDBC Connector Extension" based on CData's CosmosDB JDBC connector, but I don't know the driver's name and I'm not sure how the connection string is supposed to look like...

I'll be glad to exchange with anybody on that subject !

[slangley · Accepted solution]

Hi.

PTC does not supply the JDBC driver in these situations.  You should be able to check the vendor's site to obtain the driver and documentation for how to set it up.

Regards.

--Sharon

[VladimirRosu]

Hi Etienne, 

The driver name for any JDBC connector should be available in the documentation for that driver, meaning cdata's site.

I searched on google this, and it seems there is a page, https://www.cdata.com/kb/tech/cosmosdb-jdbc-tomcat.rst that shows an example for both the connection string and the driverClassName.

[slangley]

Hi @nmilleson.

If one of the previous posts answered your question, please mark the appropriate one as the Accepted Solution for the benefit of others with the same question.

Regards.

--Sharon