Connecting to the Database

Upon the startup of DELMIA Apriso Archiving, a dialog box presenting the connection string history is displayed.

1. You can choose one of the previous connections or enter a new connection string. While connecting to the database, DELMIA Apriso Archiving checks whether the DELMIA Apriso Archiving Engine is installed on the requested database.
• If it is not, then the user is asked to confirm installation of the DELMIA Apriso Archiving Engine
• If the DELMIA Apriso Archiving Engine is already installed on the requested database, then version check is performed and, if necessary, the user is asked to confirm the upgrade of the DELMIA Apriso Archiving Engine to the newest version
2. You can change the connection string from a running DELMIA Apriso Archiving application and connect by using this menu option: File | Connections. The same dialog as during startup with the list of historical connection strings will be presented. If the connection is successful, the user will see the current valid connection by looking at the status bar at the bottom of the main screen. A green icon is displayed together with the server and database names.
   

   

Deploying DELMIA Apriso Archiving

If you want to store archived data you need to create a new database, which will be used as a destination (Archive) database for Archiving as a copy of your source (operational) database.

1. To perform Archiving, the destination database should be an exact copy of the source (operational) database, but without any data. It is mandatory to have the DELMIA Apriso Archiving Engine installed on the destination database as well. You can deploy the DELMIA Apriso Archiving Engine to the destination database either by connecting to it or by using this menu option: File | Deploy Apriso Archiving Engine.
2. After selecting this option, the user needs to enter a valid connection string to the requested destination (Archive) database and click Deploy.

   

   If the connection string is correct, then the DELMIA Apriso Archiving Engine checks if the requested database already contains the installed DELMIA Apriso Archiving Engine and, if so, checks its version.

3. If the database server requires an installation or upgrade, then the user is asked to confirm installation of the newest version of the DELMIA Apriso Archiving Engine onto the requested database. When confirmed, the DELMIA Apriso Archiving Engine is deployed on the requested database while the connection of DELMIA Apriso Archiving to the operational database remains unchanged.
4. After the successful deployment of the DELMIA Apriso Archiving Engine onto the destination database, the user can close the dialog by clicking Close. From this point the Stored Procedures are available, which need to be called to prepare the destination database to obtain Archiving data. See Preparing a Database for Archiving for more information on how to prepare a destination database.