Please enable JavaScript to view this site.

Altova DatabaseSpy 2020 Enterprise Edition

A Global Resource is a reusable reference that represents a file or folder path, or a database connection. Global Resources are defined only once and can be reused as many times as necessary in contexts which support them, including across multiple Altova applications. Taking databases as example, if you frequently work with a specific database in more than one Altova application, then it is a good idea to add the database connection as a Global Resource. This way, you wouldn't need to go through all the Database Connection Wizard steps each time when you need to connect to the same database from another Altova application.

 

Each Global Resource can have so-called "configurations". Configurations make it possible to easily switch between files, folders and databases that are consumed or produced by Altova applications, which is particularly useful for testing scenarios. For example, you could create a database resource that consists of three separate connections to the same database, each with a different driver kind: (a) ODBC, the default connection kind, (b) JDBC, and (c) ADO.NET. This way, to connect to the database with a specific driver, you would just select the corresponding configuration from the Global Resources drop-down list.

inc-globalresource_switch

Global Resources drop-down list

 

 

To create a Global Resource:

1.On the Tools menu, click Global Resources. (Alternatively, click the Manage Global Resources _ic_global_resource toolbar button.)

2.Click Add and select the resource type you wish to create (file, folder, database).

3.Enter a descriptive name in the Resource alias text box (for example, "InputFile", "OutputFolder", "DatabaseConnection").

4.Set up the "Default" configuration:

a) If it's a file or folder, browse for the file or folder to which this resource should point by default.

b) If it's a database connection, click Choose Database and follow the Database Connection Wizard to connect to the database . This database connection will be used by default when the mapping runs (unless a different configuration is explicitly selected from the Global Resources drop-down list or supplied as a command line parameter in server execution).

5.Optionally, if the resource should have an additional configuration (for example, a driver kind in case of databases, or an alternative path in case of files or folders), click the Add configuration _ic_add_gr_config button, enter a descriptive name (for example "ProductionFolder" or "JDBC_Alternative"), and set it up as follows:

a) If it's a file or folder, browse for the file or folder to which this resource should point as an alternative to the default configuration defined in previous step.

b) If it's a database connection, follow the Database Connection Wizard to connect to the database. This database connection will be used as an alternative to the default one.

In some cases, it might be more convenient to create a configuration as a copy of the default configuration, and then edit it. In this case, click the Add configuration as a copy of the currently selected configuration _ic_copy_gr_config button.

6.Repeat the previous step for each additional configuration required.

 

Converting existing database connections to Global Resources

You can easily convert any data source connection that appears in a DatabaseSpy project to a Global Resource. To do this, right-click the connection in the Project window, and select Convert to Global Resource from the context menu.

dbs_convert_to_gr_01

The data source is added to the 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.

dbs_convert_to_gr_02

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.

© 2019 Altova GmbH