You can define personal metadata profiles for relational and nonrelational sources and targets to test connectivity and access metadata and data.
Personal metadata profiles are not required to perform bulk data movement operations or change data capture (CDC).
To view metadata for a source or target, create a personal metadata profile. View tables in the profile to see metadata for each column in the table such as datatype, date format, and CCSID. You can view metadata for multiple tables in a profile at the same time. To preview data for the source or target, run a database row test on tables in the profile.
For information about searching for tables and columns in tables in personal metadata profiles, see Searching for a Resource.
PowerExchange provides an example personal metadata profile, demo_oracle. To use this example profile, edit its properties to point to the Oracle instance.