Working with External Databases
Learn how to connect, query, insert, and handle data from an external database.
Guide Concept
This project will introduce how to utilize and incorporate an external database with the ThingWorx Platform.
Following the steps in this guide, you will connect the ThingWorx Platform to a database, insert data, execute stored procedures, and query data.
Guide Info
| Level | Expert |
| Est. Time | 60 Minutes |
| Published | July 30, 2020 |
| Author | Jason Johnson |
You'll learn how to
- Connect ThingWorx to external databases
- Query databases and and handling results
- Insert data and running stored procedures
Things used in this guide
This guide requires a connection to the ThingWorx Foundation.
It assumes that you are using a Foundation server that you have downloaded and installed or hosting yourself. You will need to be able to edit the system hosting the server.
Recommended Tasks: Create an account to perform Microsoft Web Searches used in this guide.
Completed Example: You are provided a complete example that can be utilized as a reference for completion as you go through the guide or for insight into how the following steps can be completed.
ThingWorx Foundation