Chapter 8. Creating and working with virtual databases in Fuse Online

Procedure

1. From the navigation sidebar in Fuse Online, click Data.
2. Click Create Data Virtualization.

3. On the Create New Data Virtualization page, type a name for the virtual database and click Create.

   • Provide a name that informs people about the database contents or purpose, and that is short enough for application developers and SQL users to easily insert in their code.
   • Names can include only alphanumeric ([a-z]|[A-Z], [0-9]), and hyphen (-) characters.
4. On the page for your virtualization, click Import Data Source.
5. On the Import Data Source page, click the tile for an active data source, and then click Next.

6. From the list of tables that are available, select one or more tables to include in your virtual database and then click Done.

   A confirmation message reports when the import completes. The Views tab for the draft virtualization lists a view for each table that you imported.

   You can now edit the existing views, create another view, or publish the virtual database to make it available for use.

Procedure

1. From the navigation sidebar in Fuse Online, click Data.
2. From the list on the Data Virtualizations page, find the virtual database that you want to modify and click Edit.
3. Click Create a View.
4. Expand a data source to view the tables that it contains.
5. Select the table that you want to add to the virtual database, and then click Next.

6. On the Create a View page, type a name in the View Name field, and then click Done.

   The View Editor displays the SQL for the view that you created. The Preview panel displays the data in the view.

7. If no data displays, click Refresh.

8. Click Done to close the view.

   If the virtual database was previously published, you must republish it to make the new view available.

Procedure

1. From the navigation sidebar in Fuse Online, click Data.
2. On the Data Virtualizations page, find the virtual database that you want to modify and click Edit.
3. In the Views tab, find the view that you want to edit, and then click Edit.
4. Update the SQL as needed. As you edit, press Ctrl+Space to open the code completion tool.

5. After you complete your changes, click Save.

   Fuse Online validates the SQL and returns an error if the view contains invalid code.

   After the SQL validates, the preview panel shows the result of the updates that you made to the view. The preview displays the first fifteen rows of the results set.

6. Click Done to close the View Editor and return to the list of views.

   If the virtual database was previously published, you must republish it to put your changes into effect.

Procedure

1. From the navigation sidebar in Fuse Online, click Data.
2. On the Data Virtualizations page, click Edit in the entry for the virtual database that contains the view that you want to test.
3. Click the SQL Client tab.
4. From the View field, select the view that you want to test.
5. In the Row Limit field, specify the number of rows to display.
6. In the Row Offset field, specify the number of rows to skip.
7. Click Submit. The Query Results table displays the result set.

Procedure

1. From the navigation sidebar in Fuse Online, click Data.

2. On the Data Virtualizations page, find a virtual database that you want to publish, and from the overflow menu, click Publish.

   A confirmation message notifies you that the virtual database was submitted for publishing, and a progress bar reports the status of the process.

   • If the publishing process succeeds, Fuse Online makes the following updates:

     • The status label of the virtual database entry on the Data virtualizations page changes from Draft to Published.
     • The virtual database entry displays a URL link to the OData endpoint for the virtual database.

     • The virtual database service is added to the Connections page, and a JDBC connection to it is created.

       You can verify the JDBC URL by opening the entry for the virtual database service from the Connections page.

   • If the publishing process fails, the entry is flagged with the label Error.

Procedure

1. From the navigation sidebar in Fuse Online, click Data.
2. On the Data Virtualizations page, click the overflow menu for the virtual database that you want to delete, and then click Delete.

3. When prompted, click Delete to confirm that you want to delete the virtual database.

   A confirmation message reports when the virtualization is deleted.