Tasks which write key data to a database – External memory

This example will create a task that demonstrates how External memory is used in an output step to store key data generated by a task. An SQL Server database is used as the memory location.

The task runs regularly based on a schedule, it queries the database of a database system, formats the information returned as text and sends a notification via email which at the same time commits specified data to memory.

Memory 1(1)

This task is made up of 4 steps:

Step Name Tool What it does
Daily Schedule Event: Schedule Determines how frequently the task is to run.

Scheduling a Task

Retrieve Information Input: Database Query (ODBC) Reads the database of a business system to find details to map to include in the alert.

Querying a database

Format Information Format: Format As Text Takes the results from the previous step and lays them out in a way that can be read.

Formatting Plain Text

Send Email And Commit To Memory Output: Send Email (SMTP) Sends an email containing the formatted information.

Sending an email

Send Email And Commit To Memory Memory feature within the output tool. Key information is saved to memory.

Writing key data to a database using external memory

There are two different types of memory, please follow this link for the ‘Learn about’ article ‘Internal Memory’:

Tasks which write key data to a repository – Internal memory

This type of memory uses repositories within TaskCentre to store data along with a ‘Data Filter’ step.

To read about designing other tasks see:

Task Design

Related Articles

Learn about: Writing key data to a database using external memory

This example will be using the output step Send Email (SMTP) to demonstrate the use of external memory. However, any output tool can be used as the memory feature is available to all of them. If you wish to write data to a database…

Read More