How to Integrate Thingworx 9.1 with MS Access Database

[sonali1]

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.

[SachinSharma]

@sonali1 

You can refer these links

[sonali1]

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

[slangley]

Hi @sonali1.

The ADO service is no longer available from PTC.

Regards.

--Sharon

[sonali1]

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]

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]

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