Editing a data warehouse

To edit a data warehouse, follow these steps.

1. From the Menu, click on the Manage Data Warehouses button;
2. Select the data warehouse to edit and click the Edit Data Warehouse button;
3. In the Edit Data Warehouse dialog box that appears and edit settings as required:
   1. Edit the Data Warehouse Name
   2. Edit the Data Warehouse Description
   3. Edit the Data Warehouse Login Details
   4. Edit the Data Warehouse Tables
   5. Edit the Data Warehouse Options
4. Under the Tables tab, select additional tables or deselect existing tables to replicate. You can filter the list of tables based on the source data file you want to automate;
5. Once all information is complete, click OK.

Manage Data Warehouses dialogue

Manage Data Warehouses dialogue

Edit Data Warehouses dialogue

To fully update the data warehouse and populate it with data, you must perform a Get Data. Once the Get Data process has run, you will find your new data warehouse in the ODBClink System Folder. You can now open this data warehouse and add any additional queries or business logic you need.

Video

This getting started video will show you how to add or edit data warehouses within ODBClink.

Click to load content

Adding and Editing Data Warehouses within ODBClink

Related Topics

• Managing Data Warehouses
• Adding a data warehouse
• Removing a data warehouse