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.

• External data sources