Importing tables into Data Gate

From the dashboard, you can always export existing tables to a file in comma-separated-value (csv) format. Using the csv file, you can then import the same tables into the same or into a different Data Gate instance. The import function adds the tables in a first step, and then enables table synchronization based on the information in the csv file.

Before you begin

The import function requires a csv file that contains the information about the tables. The best way to generate a csv file is to use the export function from the dashboard. On the Table tab of the dashboard, click the Export icon icon to generate the csv file. If you want to create a csv file manually, take an existing csv file as a reference to copy the table column names and the formatting of the information.

About this task

The export and import functions for tables can be used to back up and restore the system. When you have added the required tables, you can export these tables to a csv file for a backup later. If tables have been removed for some reason, or if you want to use the same tables with a new Data Gate, you can import the tables from the csv file to restore or add the tables. Tables in the csv file that exist in a Data Gate instance are ignored.

The synchronization of imported tables is handled in the following way: The csv file contains a column that is named replicationStatus. Synchronization is enabled depending on the value in this column. Any non-empty value other than Disabled enables synchronization for a table. The column replicationStatus is optional. That is, synchronization will not be enabled if the column is missing or if its value is empty.

Imported tables are not loaded automatically. The status of all imported tables is Load pending at first. Load the tables in an additional step.

Procedure

  1. Make sure that the Cloud Pak for Data perspective is selected. If necessary, click Perspective icon to change the perspective.
  2. Under My instances, click the name of the instance that you want to edit.
  3. Click Open instance.
  4. From the Table tab of the dashboard, click the import icon (Import icon), which is on top of the tables list on the right.
  5. In the Import table metadata window, you see a text box that reads Drop your table metadata file here or browse for the file (.csv) to upload. Drag and drop your csv file in this field or click the text line (it is a hyperlink) to navigate to the csv file and select it.
  6. Click Import.