Creating Basic Source Data Objects

This section discusses how to:

Define source data objects.
Specify source data object fields.
Preview results.
Preview SQL.

Note: All remote source databases must be of the same database type as the local PeopleSoft database instance. For example, if your PeopleSoft application is running on DB2/UNIX then you may only define DB2/UNIX source databases.

Pages Used to Create Basic Source Data Objects

Page Name	Definition Name	Navigation	Usage
Source Data Object	EOEW_SRCDO	select Enterprise Components, then select Data Transformation, then select Define Source Data Objects, then select Source Data Object	Create source data object definitions.
Fields	EOEW_SRCFIELD	select Enterprise Components, then select Data Transformation, then select Define Source Data Objects, then select Source Data Object, then select Fields	Specify the fields to include in the source data object.
Preview	EOEW_SRCPREVIEW	select Enterprise Components, then select Data Transformation, then select Define Source Data Objects, then select Source Data Object, then select Preview	Review the results and check the validity of the source data object.
View Query	EOEW_SRCQUERY	select Enterprise Components, then select Data Transformation, then select Define Source Data Objects, then select Source Data Object, then select View Query	Generate and view the SQL based on the source data object definition.

Source Data Object Page

Use the Source Data Object page (EOEW_SRCDO) to create source data object definitions.

Navigation

select Enterprise Components, then select Data Transformation, then select Define Source Data Objects, then select Source Data Object

Image: Source Data Object page

This example illustrates the fields and controls on the Source Data Object page. You can find definitions for the fields and controls later on this page.

Subject Area

Select a subject area.

For new source data objects, the subject area will be set to the default as defined on the Subject Area page.

Data Source Type

Local: Select to use PeopleSoft-defined records from the current database.

Remote: Select to access the remote database connection information and use records from a remote database. Select the desired data source for remote.

Note: The Data Source Type can only be selected in Add mode. If you want to change this value, you will need to create a new Source Data Object.

Source Record

Select the source records from which to extract data. This record is placed in the From clause in the extract SQL.

If multiple records are selected, join conditions are required.

Note: To change a record that is associated with a source data object, you must delete the existing record and then add the new record.

Save As

Click to save an existing source data object under a new name.

Use this function to create a new source data object that will only slightly differ from the original object. Once saved, you can make the necessary changes to the new object. The new object is maintained separately.

Fields Page

Use the Fields page (EOEW_SRCFIELD) to specify the fields to include in the source data object.

Navigation

select Enterprise Components, then select Data Transformation, then select Define Source Data Objects, then select Source Data Object, then select Fields

Image: Fields page

This example illustrates the fields and controls on the Fields page. You can find definitions for the fields and controls later on this page.

The source field information is populated from the source records that you selected on the Source Data Object page. The selected fields become the select list in the extract SQL.

Source Field Name

Select the fields to include in the source data object.

Note: At least one field must be selected. Use the Select All and Deselect all icons to make the field selection more efficient.

Field Alias

Change the field alias of any of the selected field names, if needed.

The field alias is displayed when defining the map, so descriptive names are important.

Note: All fields in the source data object must have an alias, and each alias must be unique within the source data object.

Synchronize Fields

Click to synchronize fields with the database record. It is possible over the life span of a source data object that customizations are made. If a field is added or removed from the physical table, the field list must be synchronized.

Select All

Click to select all of the fields that are listed.

Clear All

Click to clear all field selections.

Preview Page

Use the Preview page (EOEW_SRCPREVIEW) to review the results and check the validity of the source data object.

Navigation

select Enterprise Components, then select Data Transformation, then select Define Source Data Objects, then select Source Data Object, then select Preview

Click the Preview button to view a subset of the source data object based on the record and fields that are selected.

Use this feature to check the validity of the defined source data object. It is especially helpful in determining if your expressions are defined correctly.

Note: Attempting to preview complex data sources can quickly consume processing and memory resources on your application server.

The preview maximum row count is set using the Data Transformer Installation Options page. Large row counts take more time and resources to preview. Consider setting your preview row count relatively low.

If no data is returned, verify the SQL that it being used to extract the data is accurate.

View Query Page

Use the View Query page (EOEW_SRCQUERY) to generate and view the SQL based on the source data object definition.

Navigation

select Enterprise Components, then select Data Transformation, then select Define Source Data Objects, then select Source Data Object, then select View Query

Click the Generate SQL button to generate SQL text in the Query text box.

Use this to preview the SQL generated by the defined source data object.

Note: The administrator can verify if the extract SQL is correct and adjust the source data object definition as necessary.