SQL Connector
The SQL Connector allows you to connect to the following databases and perform multiple database actions:
• PostgreSQL
• SQL Server
• MySQL
• Oracle
Release version
8.5.0
Supported actions
◦ Get Rows
Supported trigger
No SQL Connector triggers are available.
Supported connector types
◦ MySQL
◦ Oracle
Prerequisites for using Oracle database
Windows
1. On the machine where the ThingWorx Flow server is installed, follow this link to install the Oracle 11.2 client libraries.
2. Add these libraries to the system PATH.
3. Use the echo %PATH% command in a new Command Prompt window to verify that the path is updated.
4. Run the pm2 restart all --update-env command.
5. Refresh the ThingWorx Flow browser page.
 |
Whenever your machine restarts, run the pm2 restart all --update-env command.
|
Linux
1. On the machine where the ThingWorx Flow server is installed, follow this link to install the Oracle 11.2 client libraries to enable connection to the Oracle database.
2. Create the flow.sh file under the /etc/profile.d directory.
3. In the flow.sh file, add the path to the Oracle library.
export LD_LIBRARY_PATH=/opt/oracle
4. Use the echo $LD_LIBRARY_PATH command in a new Command Prompt window to verify that the path is updated.
5. Run the pm2 restart all --update-env command.
6. Refresh the ThingWorx Flow browser page.