Data Sources in DatabaseSpy Projects

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Altova Global Resources > Using Global Resources >

Data Sources in DatabaseSpy Projects

When working with DatabaseSpy, you can make use of database-type global resources in several ways:

 

Add a global resource to a project as a data source
Convert an existing data source connection to a global resource
Copy a global resource into a project (and thus make it a local data source connection)

 

Adding a data source connection from a global resource

You can add a data source from a global resource either via the File | Create a Database Connection... menu or by right-clicking the Data Sources folder in the Project window and choosing Add a New Data source from the context menu. Both options bring up the Create a Database Connection dialog, where you can choose a global resource from the Global Resources page.

dlg_quick-connect-glob-res

Note that a balloon help pops up when you hover over the individual entries, showing information about the different configurations in the global resource.

 

Converting an existing data source connection to a global resource

Any data source connection that appears in a DatabaseSpy project can be converted to a global resource with a single mouse click.

tab_project-convert-to-glob-res

The data source is added to the Global Resources XML file and hence available in all Altova applications. Note that the icon in the Project window changes to indicate that the data source connection is now a global resource.

tab_project-global-resource

When you right-click the Data Sources folder in the Project window, you also have the option to convert all data sources in the project to global resources.

 

Copying a global resource into a project

If you want to use only a certain configuration of a global resource, you can add the global resource to your project, then copy it to the project as a local data source connection and remove the global resource from the project again. Make sure that you have selected the appropriate configuration before copying the global resource into the project. Only the active configuration will be available once the data source is local.

 

To copy a global resource into a project:

1.In the Project window, right-click a data source that has been added to the project as global resource and select Copy Global Resource into Project from the context menu.
2.Enter a name in the Set a Data Source Name dialog and click OK.
3.Optionally, remove the global resource from the project.

© 2019 Altova GmbH