What is meant by criteria of Updateability in MDM Import manager

[Former Member]

Hi,

What is meant by criteria of Updateability in MDM Import manager? i read some information, but i could understand, it says original data source be updateble. what is meant by Original data source.?

what is the use of option "Read-only" in Import manager logon screen.

Thanks

[Former Member · Accepted solution]

Hello Ankam,

You can check the Read-only option to prevent MDM from updating your data source.

Kindly see the below information on "DATA SOURCE UPDATES"

DATA SOURCE UPDATES

Some MDM Import Manager operations require that the original data source be updateable, thereby allowing new fields and/or entire new tables u2013 and the corresponding data values for each record u2013 to be automatically added to the data source before further processing.

Other operations simply create virtual fields in the MDM Import Manageru2019s workspace, although if the data source happens to be updateable, some of these operations instead add the new fields to the original data source as well.

NOTE ►► Updating the data source when possible allows you to

perform additional operations on the new fields as if they were part of

the original source data, and also use them as record matching fields.

NOTE ►► Fields that are added only if the data source is updateable

can be deleted automatically by the MDM Import Manager when you

exit or switch data sources based on the setting of the Delete Created

Fields on Exit configuration option.

Updateable Data Sources

Whether or not a data source is updateable depends upon the following:

u2022 Source type. The source Type must permit the MDM Import Manager to update its schema and insert the additional fields of data; some supported types are updateable and some are not.

u2022 Media. The media on which the data source resides must itself be updateable. If the media on which the data source resides is readonly, such as a CD-ROM, the data source cannot be updated.

u2022 Permissions. You must have the proper file system permissions to update the file, or the proper DBMS permissions to update the schema of the database.

u2022 Read-only option. You cannot have checked the Read-Only option, which prevents MDM from updating the data source even if the other conditions would otherwise permit it.

NOTE ►► The Read-Only option is: (1) enabled for source types that

can be updated (Access, Oracle, SQL Server, and XML); (2) disabled

and unchecked for those that use Access as an updateable staging

area (Delimited Text and Fixed Text); and (3) disabled and checked for

those that cannot be updated (Excel and ODBC).

NOTE ►► When the data source is SQL Server, the table names in

the database must not contain spaces; otherwise any operation that

would update the data source will fail.

Hope this helps.

Regards,

Vikas

[Former Member · Accepted solution]

Thanks you so much Vikas