External Database Connection
1 Introduction
The Database Connector integrates with Studio Pro with an External database connection service document. Use this document alongside the connector to connect to external databases right in Studio Pro.
This page references the External database connection document in Studio Pro. See External Database Connector for the complete documentation.
2 Connect to Database Wizard
Right-click on your module and click Add other > External database connection to open the Connect to Database wizard:
Once in the wizard, enter or select the following:
- Name — name of your database connection
- Database Type — Microsoft SQL, MySQL, Oracle, or PostgreSQL
2.1 Connecting Using Connection Details
If you select Use connection details, enter:
- Host — the hostname (
localhost
when testing locally) - Port — the port number
- Database Name — the name of the database
- User Name — the username to access the database
- Password — the password to access the database
2.2 Connecting Using Connection String
If you select Use connection string, enter the following:
- Username — the username to access the database
- Password — the password to access the database
- JDBC Connection String — the connection string, in the following formats for each database type:
- Microsoft SQL —
jdbc:sqlserver://myHostName:myPortNumber;databasename=myDatabaseName
- MySQL —
jdbc:mysql://myHostName:myPortNumber/myDatabaseName
- Oracle —
jdbc:oracle:thin:@//myHostName:myPortName/myDatabaseName
- PostgresSQL —
jdbc:postgresql://myHostName:myPortNumber/myDatabaseName
- Microsoft SQL —
3 External Database Connection Document
After entering your database information in the Connect to Database wizard, the external database connection document is open in Studio Pro.
The name of the document is the Name (not Database name) you provided when running the wizard:
3.1 Query Screen
On the left side of the document is the Query screen. Here, you can write an SQL query to retrieve data and run it to validate its response.
View data from the database in the Tables & Columns screen on the right.
This screen includes the following fields:
- Query Name — query name, which is saved and can be used later
- SQL Query — text box where you can enter your query
In the Parameters section, click Add Parameter to enter the following information:
- Name — name of the parameter that can be used in the SQL Query field (in the form of {parameter_name})
- Data Type — select the type of data for your parameter
- Test Value — enter or select the value of the parameter
Click Execute Query to view a preview of the reponse.
3.2 Tables & Columns
The Tables & Columns field on the right side of the screen displays the information from your database. You can use queries to access certain information in your database.
3.3 Response
After querying the database, you can view the data included in the query in the Response screen.
If you are satisfied with the response, click Use Response. This will take you to the Data Structure tab where you can preview and create an entity from the response.
3.4 Response Structure
The Data Structure tab displays a preview of an entity that can be created from the response of your query. You can adjust the name, or move back to a previous step. Click Save Query & Create Entity to create the entity in your domain model.
4 Read More
To learn about how to use the data in a microflow, see the Query External Database activity.
Feedback
Was this page helpful?
Glad to hear it! Thank you for your response.
Sorry to hear that. Please tell us how we can improve.