User Guide > Managing Schemas > Creating Schemas > Creating Schema Using External Connection
Was this helpful?
Creating Schema Using External Connection
To create a schema using an external connection:
1. Select a DataConnect project and do any of the following:
Go to File > New > Schema.
Click the arrow in /download/attachments/24975435/ProjectExplorer_New_Icon.png?version=1&modificationDate=1489226055250&api=v2 and then click Schema.
Right-click on the project and then click New > Schema.
The New Schema File page is displayed.
If v9 compatibility mode is enabled, then when you select any of the preceding option, the Select a Schema Type window is displayed. Select Structured Schema and click Next.
2. Select the project where you want to create the schema and in the Schema File Name field, type a name for the schema, and click Next.
The Select Schema Type and Connector page is displayed.
3. Specify the following:
Choose Schema Type - Select Source to create a schema for the source data or Target to create a schema for the target data.
Choose Connector - From the drop-down list, select a connector. Connections determine the data types that will be used in building the schema.
4. Click Next.
The Select Schema Creation Method page is displayed.
5. Select Establish External Connection and click Next.
The Define Your Connection page is displayed.
6. Select a connector or connection and specify the related properties. For more information about parts and properties, see Setting Up Target Data.
Note:  For multimode connectors, you must select a schema using /download/attachments/25954037/SelectIcon_WithinField.png?version=1&modificationDate=1493578526343&api=v2. Also, if all tables are required, then click Select All.
7. Click Next.
The Select Records page is displayed.
8. In the Add to Layout column, select the check boxes to specify the records that you want to add to the schema. You can also:
Select the Select All option to add all records to the schema.
Select the Include Children option to include the child records to the schema.
9. Click Finish.
A new schema file is created and it opens as a separate tab. The file extension for schema is .schema. The records you had specified to be included to the schema are displayed in the file.
For information about the Schema Editor, see Exploring Schema Editor.
Last modified date: 08/02/2023