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

How to Integrate Thingworx 9.1 with MS Access Database

sonali1
5-Regular Member

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
SachinSharma
14-Alexandrite
(To:sonali1)

@sonali1 

 

You can refer these links

 

sonali1
5-Regular Member
(To:SachinSharma)

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

slangley
23-Emerald I
(To:sonali1)

Hi @sonali1.

 

The ADO service is no longer available from PTC.

 

Regards.

 

--Sharon

sonali1
5-Regular Member
(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 I
(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 I
(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

Announcements