Follow

Table and Column Selection in an ODX Instance

Selecting Tables and Columns from ODX Data Sources

Right-click on the data source and choose Select Tables... in order to select tables and columns on the data source level. Any transfer tasks for the data source will be limited to the data that has been selected on the data source level.

mceclip0.png

 

By default we see the advanced selection menu, which is based on table and schema name rules. Search for and select the tables and then press Include.

mceclip1.png

 

A list of rules will then appear in the right-hand pane based on your selection.

mceclip3.png

We can then choose Select Columns... to search for columns, and limit the number of columns that are selected. This column selection logic also relies on rules, which are based on schema, table and column names. In the below example I have searched for the columns containing the string "id" at the end of the name, by searching for columns like "%id".

mceclip6.png

Check the columns you wish to include and then select Include.

mceclip7.png

A list of rules then appears in the right hand pane of the menu.

mceclip8.png

We can also use the simple selection feature, which is not rules based, by clicking on Switch to Simple Selection... The schema, table and column rules are converted to simple selections. In the right hand pane, "regions (1/2)" indicates that the region table has 1 out of 2 columns selected. 

mceclip9.png

If we click on "regions (1/2)" and choose Select Columns... we will see a simple mode column selection menu. Click Remove to remove a column, click Add to add a column, or select Load Preview Data to generate a preview of the data in each column.

mceclip10.png

 

Selecting Tables from Transfer Tasks

You may also choose to select tables on a transfer task level (rather than a data source level). If a table or column has not been chosen on the data source level, then it cannot be chosen on a transfer task level. In order to add a new table to the transfer task, you will first have to select the table on the data source level and execute the synchronization task. Please note, that column selection is only available on the data source level, not on the transfer task level.

 

If you are adding a new Transfer Task to your data source, right-click on your data source and select Add Transfer Task...

mceclip0.png

There is an option to add all tables to the new transfer task. Alternatively choose Let me select the tables in order to open the table selection menu.

mceclip7.png

If you have already created a transfer task, you can right-click and choose Select Tables in order to open the table selection menu.

In the Table Selection menu, you may filter the results on schema or table names, and add or remove specific tables to transfer.

mceclip1.png

You may also "Switch to Advanced Selection" to apply a rule-based selection, which considers schemas and/or tables names.

mceclip2.png

mceclip3.png

After selecting tables, execute the transfer task to load tables from source to ODX storage.

Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.