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

The list of activities for this action are arranged below in alphabetical order. 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 via 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 via 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.