In this Topic Hide
What Are Archive Bus Stops For?
How to Create Archive Bus Stops
Archive Bus Stops can be configured to look for specific message types for specific operations on the bus. The messages are recorded in an Archive database which can then be referenced for historical data. This data can also be used by ATS ARS and other reporting and analysis systems to generate production and quality reports.
To create a bus stop that will communicate with equipment on the shop floor you need to carry out the following steps:
2. Create Message Channels
Archived messages are stored in a separate archive database which can be created directly from Cockpit.
If an existing database name is used the database will be deleted and a new one created. All existing data will be lost.
5. Select the Archive Bus Stop tab.
6. Click Archive Bus Stops.
A list of the existing bus stops is shown.
7. Click Add to create a new bus stop or select an existing bus stop and click Edit.
The Archive bus stop dialog opens.
8. Select the Database Configuration tab.
9. Select the Database Type (Microsoft SQL or Oracle)
10. Enter the Database Server. The user should provide the server instance in one of the following ways:
o Hostname or IP: for default instance
o Hostname\Instance or IP\instance: for a specific instance
11. Enter the Database Name.
This cannot be equal to the ATS Bus configuration database.
12. Enter a Login and Password for the database.
13. Enter an Administrator login and password. The administrator must have elevated rights.
The User login must be different from the Administrator login. The user login is used by the archive bus stop to put messages in the archiving database.
14. Click Create Database.
The database is created.
The Test Connection button is used to test if the user provided can connect to the given database and whether the database should be updated to a newer version. This is used when providing an existing ATS Bus archiving database.
1. While editing an Archive bus stop select the Database Configuration tab.
2. If not already entered, enter the Archive database details as described above.
3. Click Test Connection.
The connection to the database is confirmed and the version of the database is displayed. If it isn't the latest version it will say so.
4. If needed click Update Database Schema.
The database is updated to the latest schema.
An existing database can be updated to the latest schema as follows.
1. While editing an Archive bus stop select the Database Configuration tab.
2. If not already entered, enter the Archive database details as described above.
3. Click Test Connection.
The connection to the database is confirmed and the version of the database is displayed. If it isn't the latest version it will say so.
4. Click Update Database Schema.
The database is updated to the latest schema.
Click Test Distributed Transaction Capabilities to check that the archive database can work within the network.
This is only for use when testing an MS DTC configuration.