ODBC
Introduction
This module imports data from ODBC data sources into Proto as entrysets. It provides read access to any ODBC compatible data source using standard connection string and query commands. Given a connection string and query, the ODBC Module performs the query on the target data source and outputs the results in an entryset on the "Get Data" output connector. The two configuration parameters "connection string" and "query" may be specified via either the Property Panel or their corresponding input connectors. The ODBC module does not include the ability to automatically refresh its data set when the source changes. All refreshes must be triggered via the "Do Refresh Query" input connector.
Property Panel:
ODBC Module Properties
- Connection String
- The connection string used to connect to the ODBC data source is specified here.
- Query
- The query used to request data from the ODBC data source is specified here.
See Also:
Input Menu:
Set Connection String
Sets the ProtoDB from which data is read.
Accepted Datatypes:
- Text
- Valid ODBC connection string.
Triggered Outputs:
- Output Message:
- Get Data
Set Query
Sets whether or not to reload the selected ProtoDB when it receives a notification that it has been updated elsewhere.
Accepted Datatypes:
- Text
- Valid ODBC query.
Triggered Outputs:
- Output Message:
- Get Data
Do Refresh Query
Refreshes from the connected database and sends an updated entryset to the "Get Data" output connector.
Accepted Datatypes:
- Any
Triggered Outputs:
- Output Message:
- Get Data
Output Menu:
Get Data
Gets an entryset containing the data retrieved from querying the ODBC database.
Output Datatype:
- Entryset
Triggered By:
- Input Message:
- Set Connection String
- Input Message:
- Set Query
- Input Message:
- Do Refresh Query