Follow-On Topics

Related Topics

# Creating a New Repository

Repositories may be created using four different methods:

Method 1 — Automatically Create a Repository

The first method is to automatically create a Repository using the memory feature of an Output Step for a Task; which memorises specified data when a Task is run.

To create a Repository for a Task:

1. Open the Task by double-clicking on the applicable Task in the Items List. The Design Tab of the Task dialog box will be displayed.
2. Double-click on the applicable Output Step to open its configuration dialog box.
3. Select the tab containing the Memory button and then click on the button. The Memory Definitions dialog box will be displayed.
4. Click on the Add button. The Please select a Memory Provider dialog box will be displayed.

   1. Select the Internal Memory option and click on the OK button. The Internal Memory dialog box will be displayed.
5. Enter a name for the internal memory.
6. Enter a name for the Repository. A default name made up of the folder and Task name is initially provided but this may be edited as required. If an existing Repository was being used then it could be selected through the Select Repository button which opens the Select Repository dialog box.
7. Drag and drop the columns to be memorised into the Items to Memorise table from the Task Browser dialog box.
8. Select other memory options provided in the dialog box as required and then click on the OK button. The Internal Memory dialog box will be closed and the Repository created.
9. Click on the OK buttons to close all open dialogs.
10. The new Repository may then be viewed in the Repository dialog box by double-clicking on the Repository name in the Items List with the Repositories node selected in the Task Manager, but will obviously contain no data until the Task is run for the first time.

Method 2 — Manually Create a Repository

The second method is to create a Repository manually. Data columns may then be created and new records / values added.

To manually create a Repository:

1. Select the Repositories node in the Task Manager.
2. Right-click in the Items List and select the New option from the menu. The Repository dialog box will be displayed.
3. Select the Details tab and enter a name and a description for the Repository.
4. Click on the Permissions button to open the Permissions dialog box and select or add the Users who will have access to the Repository.
5. Select the Schema tab. Click on the Add button to open the Properties dialog box to add a table to the Repository schema.
6. Enter a table name and click on the Add button to open the New Attribute dialog box through which a new column may be added to the table. Enter a name for the new column and click on the OK button to close the dialog box. The new column will be displayed in the Definition table.
7. Select the required attributes for the column and then add other columns as required. Then click on the OK button to close the Properties dialog box.
8. We can now add new records to the table. Select the Data tab. Right-click on the Repository name node and select the Insert Row At The End option. A new row is created under the node.
9. Click on the new row to display the columns in the right pane. Double-click on a column to open the Edit Value dialog box and enter a value for the column. Click on the OK button to close the dialog box.
10. Add values for all columns using the same method.
11. Continue adding new rows and then column values as required.

Method 3 — Import Data from One Repository to Another

The third method is to import the data from a previously exported Repository `.xml` file into a new Repository.

With this method the existing schema is used so that the table and column names are the original names used.

To import a previously exported Repository .xml file:

1. Select the Repositories node in the Task Manager.
2. Right-click in the Items List and select the Import option from the menu. The Repository Import dialog box will be displayed.
3. Enter the file path and name in the XML File field or locate and select using the Browse button.
4. Enter a new name in the Repository Name field.

Method 4 — Create a Repository from a CSV File

The fourth method is also to import data into a new Repository from either a previously exported `.csv` file or a new `.csv` file.

The difference between this method and Method 3 is that a schema is created before the data is imported. Columns being imported may therefore be mapped to the newly created columns.

1. Carry out the first 7 steps from Method 2 to create the Repository and the required tables and columns.
2. Click on the Import button. The Step 1 - Import Data dialog box will be displayed.
3. Locate and select the required file through the Browse button and select the appropriate options in the dialog box.
4. Click on the Next button. The Step 2 - Map Columns dialog box will be displayed.
5. Click on each of the columns in turn and select the column from the imported file to map against the existing columns.
6. Click on the Finish button to complete the importing process.

Copyright © 2018 Quadrant Software B.V. All rights reserved.