Creating and Managing Data Stores

The Data Stores workspace is used to configure and manage data stores.

Once an item is selected from the Navigation Pane, it can be viewed or modified using the following tabs:

• General - standard metadata relating to the selected item.

• Input Details - connection details to the database for importing data into 1Integrate.

• Input Mapping - mapping from the schema of the external data source to the 1Integrate session schema.

• Output Details - connection details to a database for exporting data from 1Integrate.

• Output Mapping - mapping from the 1Integrate session schema to the schema of the external data source.

  Note: Output mapping is only used for Copy To tasks in a session. If using a Commit task then the inverse of the input mapping is used and the output mapping is ignored.

Creating Data Stores

New Data Stores can be created from the Navigation Pane.

Once created, data stores can be configured using Input and Output Mapping (see Schema Mapping).

Create a Data Store

1. Navigate to the Data Stores page.

2. Within the Navigation Pane, select the folder in which you want to create a new data store.

3. Select New > Data Store.

   A new data store will be created with a default name "New Data Store [n]".

4. Within the General tab, use the Name field to enter a new name for the data store.

   Once you have typed a name, click outside of the text field to ensure it will be saved.

5. Click Save.

Moving and Deleting Data Stores

Data Stores can be moved or deleted using the Navigation Pane.

Note: You cannot use keyboard shortcuts such as Ctrl+C to move or copy items.

Note: To move or copy into the top level, select the title of the list of items as your target folder.

Copy a Data Store

1. Navigate to the Data Stores page.

2. Within the Navigation Pane, select the data store to be copied.

3. Select Edit > Copy, or right-click on the data store and select Copy.

4. Select the target folder (in which to place the copied data store).

5. Select Edit > Paste, or right-click on the target folder and select Paste.

Move a Data Store

1. Navigate to the Data Stores page.

2. Within the Navigation Pane, select the data store to be moved.

3. Select Edit > Cut, or right-click on the data store and select Cut.

4. Select the target folder (in which to place the data store).

5. Select Edit > Paste, or right-click on the target folder and select Paste.

Delete a Data Store

1. Navigate to the Data Stores page.

2. Within the Navigation Pane, select the data store to be deleted.

3. Select Edit > Delete, or right-click on the data store and select Delete.

4. In the confirmation box that appears, click OK.

5. The data store is moved to the recycle bin.

   Note: If the recycle bin already contains an item of this name, a suffix is added to make the name unique.

   Note: You cannot delete an item if a shortcut has been defined for it and still remains in the navigation pane.

   Note: You cannot delete an item if it is associated with a session.