Synchronize Data Objects
Synchronize the changes to a flat file or table data object with its external data source. If the external flat file or table data source changes, you can synchronize the changes to the flat file or table data object in the Analyst tool.
You can synchronize the changes to a data object with its external data source from the Discovery workspace. You can also open a data object in the Library workspace and right-click the data object to synchronize it with its external data source.
Synchronizing a Flat File Data Object
You can synchronize the changes to an external flat file data source with its data object in the Analyst tool. Use the Synchronize Flat File wizard to synchronize the data objects.
1. Open the Library workspace.
2. In the Projects section, select a flat file data object from a project.
The Analyst tool displays the data preview for the flat file in the Data Preview tab.
3. Click the Properties tab.
4. From the Actions menu, click Synchronize.
The Synchronize Flat File wizard appears.
5. Choose to browse for a location or enter a network path to import the flat file.
- - To browse for a location, click Choose File to select the flat file from a directory that your machine can access.
- - To enter a network path, select Enter a Network Path and configure the file path and file name.
6. Click Next.
7. Choose to import a delimited or fixed-width flat file.
- - To import a delimited flat file, accept the Delimited option.
- - To import a fixed-width flat file, select the Fixed-width option.
8. Click Next.
9. Configure the flat file options for the delimited or fixed-width flat file.
10. Click Next.
11. Optionally, change the column attributes.
12. Click Next.
13. Accept the default name or enter another name for the flat file.
14. Optionally, enter a description.
15. Click Finish.
A synchronization message prompts you to confirm the action.
16. Click Yes to synchronize the flat file.
A message that states synchronization is complete appears. To view details of the metadata changes, click Show Details.
17. Click OK.
Synchronizing a Relational Data Object
You can synchronize the changes to an external relational data source with its table data object. External data source changes include adding, changing, and removing source columns and rule columns.
1. Open the Library workspace.
2. In the Projects section, select a table data object from a project.
The Analyst tool displays the data preview for the table on the Data Preview tab.
3. Click the Properties tab.
4. From the Actions menu, click Synchronize.
A message prompts you to confirm the action.
5. To complete the synchronization process, click Yes.
A synchronization status message appears.
6. A message that states synchronization is complete appears.
To view details of the metadata changes, click Show Details.
7. Click OK.