Skip to main content
Siddharth_Jhs14-Alexandrite
14-Alexandrite
Aug 23, 2023 11:21 AM UTC
Solved

How to connect Oracle Data Warehouse from Thingworx Platform

Hello All,

I have a requirement to query data from Oracle Data Warehouse to Thingworx Platform. Any interface connectivity like ODI or JDBC example exists which I can leverage in my solution. Any leads would be appreciated. 

 

Regards,

Sid

 

PaiChungAnswer
22-Sapphire I
Aug 23, 2023 11:48 AM UTC

I haven't seen any recent ones, but you should be able to make an extension for this, allowing you to connect using the 'Database Thing/ThingTemplate' within ThingWorx.

The 'hack' would be to drop the appropriate jdbc jar file in the Tomcat inf folder

View in thread

5 replies

PaiChung22-Sapphire IAnswer
22-Sapphire I
Aug 23, 2023 11:48 AM UTC

I haven't seen any recent ones, but you should be able to make an extension for this, allowing you to connect using the 'Database Thing/ThingTemplate' within ThingWorx.

The 'hack' would be to drop the appropriate jdbc jar file in the Tomcat inf folder

Translate
    Siddharth_Jhs14-AlexandriteAuthor
    14-Alexandrite
    Aug 31, 2023 2:29 PM UTC

    Could you please provide me any sample example to create database extension. 

    Thanks,

    Sid

     

     

    Translate
    slangleyCommunity Manager
    Support
    Aug 31, 2023 8:14 PM UTC

    Hi @Siddharth_Jhs.

     

    Here are the instructions for creating an extension.  ThingWorx also offers the ability to configure access to an external database without the need to create an extension.  

     

    Regards.

     

    --Sharon

    Translate
      Terms & ConditionsAccessibility statement