Skip to main content
S
Siddharth_Jhs14-Alexandrite
14-Alexandrite
August 23, 2023
Solved

How to connect Oracle Data Warehouse from Thingworx Platform

  • August 23, 2023
  • 1 reply
  • 2105 views

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

 

Best answer by PaiChung

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

1 reply

P
PaiChung22-Sapphire IAnswer
22-Sapphire I
August 23, 2023

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

    S
    Siddharth_Jhs14-AlexandriteAuthor
    14-Alexandrite
    August 31, 2023

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

    Thanks,

    Sid

     

     

    S
    slangleyCommunity Manager
    Community Manager
    August 31, 2023

    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

      Terms & ConditionsCookie settingsAccessibility statement