Including Views as Database Schemas

By default, when you create a database data source and import a predefined schema, views are excluded from the list of schemas that are available to import. However, you can configure the Anzo Database DataSource Provider Service to include views as schemas. Follow the steps below to remove views from the list of table types that are excluded from import.

  1. In the Administration application, expand the Servers menu and click Advanced Configuration. Click I understand and accept the risk.
  2. Search for the Anzo Database DataSource Provider bundle and view its details.
  3. Click the Services tab and expand com.cambridgesemantics.anzo.database.IDbConnectionService.
  4. Locate the com.cambridgesemantics.anzo.database.excludeTableTypes property (shown in the image below).

  5. Click the property to make it editable, and then delete the word VIEW.

  6. Click the checkmark icon () for that property to save the change.
  7. Restart Anzo to apply the configuration change.

The service is now configured to display views in the Import Schemas dialog box.