Data can be imported to interface tables from other systems into the Clausion Financial Performance Management database for example using the SQL Server Integration Services (SSIS), component of the Microsoft SQL Server database software.

Note! Clausion interface specialists have good experience on defining the runs, and they should at least be involved in the interface project as advisory member.

Executing SSIS run

The Clausion Financial Performance Management system includes a custom template for executing SSIS runs.

•Mark the run with "X" in the first column of the template and click save to execute.

With the default template you may not execute several manual runs at the same time.

Adding and modifying runs

You can add and modify automatic runs on the SSISLaunch Auto worksheet of the template:

•Add a name, description, data type, year and period for the run and save.

When you save the custom template, manual runs selected on the SSISLaunch Manual sheet are also executed. The template usage requires SSIS runs to be defined in the server. Clausion interface specialist instructs the customer in more detail during the interface implementation project.