Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
Hi,
I am new to this platform. Trying to create dashboard from Oracle Database tables.
Can someone provide me some help.
I've ThingWorx s/w installed on the windows o/s.
thanks for your help.
Rao
Hi Rao.
My recommendation would be the following:
- Install the latest extension packages esp. the ones for MySql and MSSQL.
- Use the training instructions and examples to get familiar with DB connections using a MySql DB
- Create a connection to an Oracle DB using the information in this post here: https://twc.thingworx.com/Thingworx/Runtime/index.html#master=ThingWorxCommunity&mashup=TWCBlogSearchResult&blog=GeneralCommForum&entryID=71625
- and have fun.....
Best Regards,
Rayed
Hi Rayed.
I am facing a similar problem. I clicked on this site, but it asks me for credentials. How can I register to this site?
Thanks and Regards,
Jyothi
All documentation has now moved to support.PTC.com
Also I recommend our eLearning precisionlms.com which has some sections that walk you through a sample database interaction.
I have already taken that course. Actually I also have created an Oracle Extension. But it is not working.
Jyothi,
This will allow you to connect to ORACLE DB:
Obtain jdbc driver:
Download ojdbc6.jar
from
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html
and drop it in lib/ directory of Tomcat and then restarted tomcat.
Database Thing Setting:
Name Value
JDBC Driver Class Name - oracle.jdbc.driver.OracleDriver
JDBC Connection String - jdbc:oracle:thin:@ORACLE-SERVER-NAME:PORT/SID
connectionValidationString - select sysdate from dual
Maxium Number of Connections - 5
Database User Name - USERNAME
Database Password - ********
Please note, you may be affected by: http://stackoverflow.com/a/20508453