SQL Components and Properties
Use SQL components and their properties to issue ODBC, OLE, Oracle, and SQL queries and commands in your automations.
SQL components are found under the External data sources tab of the Toolbox.

Properties are defined in the Property Grid, to the right of the Automation Surface. Methods are defined directly in the Connection Block on the Automation Surface.

- ODBCQuery
Use the ODBCQuery when connecting to an ODBC provider. ODBC (Open Database Connectivity) is a standard software API designed to connect to database management systems. It is designed to be independent of any specific language or operating system.
- OleDbQuery
Use the OleDbQuery when connecting to an OLE database provider (such as Access).
- OracleQuery
Use the OracleQuery when the data source you want to use in your automation resides in an Oracle database.
- SqlCommand
Use SQLCommand when the data source resides in a Microsoft SQL Server database and you want to perform update, insert, or delete commands on the database.
- SQLQuery
Use the SQLQuery when the data source resides in a MS SQL Server database.
Previous topic External data sources Next topic ODBCQuery