cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

How to Integrate Thingworx 9.1 with MS Access Database

sonali1
6-Contributor

How to Integrate Thingworx 9.1 with MS Access Database

I want to integrate thingworx 9.1.3 with ms access database and read the MDB files.

Please help me with the steps to configure the same.

6 REPLIES 6

@sonali1 

 

You can refer these links

 

sonali1
6-Contributor
(To:SachinSharma)

I am unable to access the link for ADO service provided on the post 

slangley
23-Emerald II
(To:sonali1)

Hi @sonali1.

 

The ADO service is no longer available from PTC.

 

Regards.

 

--Sharon

sonali1
6-Contributor
(To:slangley)

Can you let me know instead of the ADO service, what can I use to establish connectivity between the Thingworx 9.1 and MS Access database.

slangley
23-Emerald II
(To:sonali1)

Hi @sonali1.

 

You can try setting up a jdbc connector thing using the database template.  You'll have to search for a jdbc connector for MS Access on the web since it's not one we provide. There doesn't appear to be an official driver from Microsoft, so it may require some trial and error to find one that works the way you expect.

 

Regards.

 

--Sharon

slangley
23-Emerald II
(To:slangley)

Hi @sonali1.

 

If you feel your question has been answered, please mark the appropriate response as the Accepted Solution for the benefit of others with the same question.

 

Regards.

 

--Sharon

Top Tags