Database

Description

Most organizations today depend largely on databases for their day to day business operations. Increasingly, databases are not only used to support the internal operations of the organization, but also to strengthen collaborations with customers, suppliers and other business partners.

From IT professionals to novice users, Automate is the ideal software for automating database processes and applications. The SQL Query and Stored Procedure activities allow you to create sophisticated database-driven applications without the need to write code. They support SQL Server, Oracle, Access, Sybase, DB2 and other ODBC-based database. You can automate report generation and distribution, run DTS or similar database maintenance processes automatically and expand tasks to do even more using Automate's library of actions and activities.

Available Activities

For more information about a specific activity, click the associated link. 

Activity	Description
Database - Close SQL Connection	Closes a previously established connection created by an Open SQL Connection activity and ends the session.
Database - Open SQL Connection	Opens a database connection using a custom or predefined connection string.
Database - SQL Query	Passes an SQL (Structured Query Language) statement including queries to the data source specified by way of OLEDB. If a query is specified, an Automate Dataset with the name you indicate is created and populated with the query results.
Database - Stored Procedure	Executes the selected stored procedure by way of OLEDB on the data source specified. Stored procedures are configured on the database server and are often faster than repeated SQL calls. A working knowledge of SQL is necessary to get the most out of this activity.