You can map source tables for a subscription to an external
datastore.
About this task
When you are mapping to an external target datastore, the
organization that owns the external target datastore must first add
tables to the subscription before you can map the tables. After adding
tables to the subscription, you can map tables using one of the available
mapping types.
Procedure
- Click
.
- Select a subscription, right-click and select Map
Tables.
- Select the mapping mode and type, depending on the number
of tables you want to map and the structure of them.
- Click Next.
- Expand the database, schema, or table from the
Source Tables list to view tables from your database that are available for
mapping. Right-click the database user or schema and click Refresh if you do
not see your table listed.
You may be prompted to filter databases, schemas, or tables
if Automatically prompt for filter when expanding nodes is
enabled in your preferences. For more information see, Setting advanced preferences. To manually
define a filter, select a datastore, database, or schema and click Specify
Filter.
- Enable one or more tables to map from the
Source Tables list. If you do not see your table listed, right-click the
database user or schema and select Refresh.
- If you want to hide columns so that the target is not
aware of them, select a source table and click Filter Columns. Clear the
check box for the column you want to hide and click OK.
- Click Next.
- Review the mapping settings.
- Click Finish.