Selecting SQL Table and View Objects for Import This page last changed on Feb 14, 2008. ## Selecting SQL Table and View Objects for Import To create a physical data service based on a relational table or view: Select the Tables and Views option Click Next. A list of available database table and view SQL objects appears. Objects are grouped based on the relational data sources catalog and/or schema. In the example of an RTLCUSTOMER catalog, the ADDRESS and CUSTOMER tables both become physical data services.
| Database-specific Catalog and Schema Considerations
Simply check the desired objects or their container, which will select all enclosed tables or views. ##### Table and View Objects Selected for Import If you click on an individual object such as ADDRESS or CUSTOMER, information describing the database's primary key(s), column name, type and nullability appears. For example the CUSTOMER table contains a CUSTOMER_ID field of type VARCHAR. That column is not nullable, meaning that it must be supplied with any updates. ##### Physical Data Service Properties

Document generated by Confluence on Jan 13, 2009 15:57