SQL command tools

Each database management system includes some form of an SQL command tool. For example, ODBC data sources can be accessed using tools such as Microsoft Query to test queries and view information about your tables, views, and stored procedures. Oracle databases can be accessed using SQL Plus; Microsoft SQL Server data sources can be accessed with ISQL.

These tools provide the ability to determine the problem by testing your queries against the database using the same drivers being accessed by the database adapters.

For example, if you run a map that executes a query for a data source and it fails because one or more of the column names was invalid, you could copy the query text from the Database Interface Designer and test it using the SQL command tool for your database. Then, you could modify the query as necessary to get it to work correctly. When you achieve the expected results, copy the SQL statement back to the query defined in the Database Interface Designer.

Similarly, if a database insert or update operation fails, you could try entering the corresponding INSERT or UPDATE statement into your database system's SQL command tool to help determine the cause of the failure.