Database Actions
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, 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 report generation and distribution, run DTS or similar database maintenance processes automatically and expand tasks to do even more using 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 |
|---|---|
|
Closes a previously established connection created by an Open SQL Connection activity and ends the session. |
|
|
Opens a database connection using a custom or predefined connection string. |
|
|
Passes an SQL (Structured Query Language) statement including queries to the data source specified via OLEDB. If a query is specified, a Dataset with the name you indicate is created and populated with the query results. |
|
|
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. |