To Add the Tables to the EDM Collaboration

Before You Begin

Before creating a join, you must have a virtual database, Data Mashup project, the NetBeans IDE must be running, and you must be connected to the virtual database.

1. If necessary, connect to the virtual database.

   1. In the NetBeans IDE, click the Services tab and expand Databases.

   2. Right-click the database you want to start and select Connect.

      In this procedure, start VirtualMashupDB.

2. In the NetBeans IDE Project window, expand the Data Mashup project.

3. Under Collaborations, double-click the EDM collaboration (demoDMfile.edm for this exercise).

   The file opens in the EDM Editor canvas.

4. Right-click in the EDM Editor canvas and select Add Table.

5. In the Select Source Table window, select the virtual database you created earlier (VirtualMashupDB).

   The tables in the database appear under Schema.

6. Highlight the SUPPLIER_ADDRESS and COMPANY_DATA tables and click Select.

7. Click OK.

   The window closes and the tables, along with Runtime Input, appear on the canvas. You are now ready to create the join.