dashboards from Oracle database table.

[ptc-493315]

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

[rhawa]

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

[jrajesh]

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

[paic]

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.

[jrajesh]

I have already taken that course. Actually I also have created an Oracle Extension. But it is not working.

[aamit]

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