17-Peridot

Solved

Connect to Azure Cosmos DB with SQL API

Forum|Forum|7 years ago
November 15, 2018
5 replies
3516 views

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!

Best answer by slangley

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

C

CRArko

5-Regular Member

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.

E

Etienne

1-Visitor

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 !

S

slangley

Answer

Support

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

S

slangley

Support

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

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.