| | |
|
To start this tutorial, you have to complete the "How to create a Db Connection Metadata" tutorial first.
Next
|
 |
| | |
 |
 | Create a Table schema metadata
|
In the Repository on the left of the Talend Open Studio main screen: Expand the Metadata > RemoteDBMS node.
Right-click on RemoteDBMS. In the menu, click Retrieve Schema to open the Schema wizard. |
 |
In the Schema wizard: In the Select Filter Conditions area, select Use the Name Filter or Use the Sql Filter depending on the type of filter you want to use. In the Select Types area, select the type of item you are looking for: table, view and/or synonym. In the Set the Name Filter or Set the Sql Filter areas, set the filter you want to use. For this tutorial, left the default settings.
Click Next. |
 |
In the Select Schema to create area, enter the name of the table you are looking for in the Name Filter field and check the corresponding box in the Name list, or simply check the table in the list. Here, we select the customers, states and subscribers tables. Click Next. |
 |
In the Schema area on the left of the wizard, select the table. Once selected, you can modify its schema.
|
 |
The name of the table displays in the Name field at the top of the wizard. The Schema area at the bottom of the wizard displays the structure of the table. You can modify it via the toolbar below the table.
|
 |
In the Schema area, select columns you want to delete and click [x]. Delete id2, Sum1, Sum2.
Rename the columns. Click the Column you want to rename and enter the new name. Change the Type of data in the list. The corresponding DB Type field will automatically be modified. Check Key and Nullable boxes if necessary. Modify the Length of your columns. Click Finish.
|
 |
In the Repository on the left: The new schemas are displayed in the Metadata > Db Connections > RemoteDBMS > Table schemas node.
|
