PowerExchange for MongoDB User Guide

10.4.0
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4

Back Next

Updating the Schema File

You can update the schema file to reflect metadata changes in the MongoDB database or make changes in the imported metadata.

Open the schema definition by using the Informatica MongoDB ODBC Driver DSN.

Click

Browse

and select a schema definition file.

You can also enter a file name in the file selection dialog box to create and use a new schema definition file.

Export the metadata to the SSD file.

To export the metadata imported by using the MongoDB ODBC driver, click

Export Existing

To export metadata sampled from the MongoDB database, click

Generate All

To export any missing tables and add metadata, click

Generate Missing

From the

Database source table

list, select the table to be updated.

Click

Generate Table

to update the schema of the table from the database.

Click

Edit Schema File

to open the schema file that you exported.

In the

Schema Editor

, make the required modifications in the schema file to reflect the metadata changes.

When you update metadata, press

Enter

and then click

Save

to ensure that the changes to the metadata are saved.

Save the schema file and close the

Schema Editor

dialog box.

In the

Schema Definition

dialog box, click

Update Metadata

to replace the metadata with the metadata from the SSD file.

Defining the Schema for a Collection

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

PowerExchange for MongoDB User Guide

PowerExchange for MongoDB User Guide

Updating the Schema File

Updating the Schema File