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.
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.
Use the OleDbQuery when connecting to an OLE database provider (such as Access).
Use the OracleQuery when the data source you want to use in your automation resides in an Oracle database.
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.
Use the SQLQuery when the data source resides in a MS SQL Server database.