Database

Overview

Most organizations 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 Desktop is ideal 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 Desktop 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 Desktop Dataset with the specified name is created and populated with the query results.
Database - Stored Procedure	Executes the selected stored procedure using OLEDB on the specified data source. 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.