What are Locations?

A location is a logical mapping of a database and a schema.

Every Tx Project requires a default location. This default location cannot be deleted, although additional locations can be added.

Locations are global to the project, shared among project users.

The location mapping is personal to each specific user, but the list of locations is set for the entire project.

Benefits of Locations

Consistent Object Management: Every Transformational (Tx) Object must have a location to be identifiable within the database.
Ease of Movement: Tx Objects linked to a location can be moved across environments without renaming the location. Environments is a feature that is coming soon.
Environment Settings: Different environment settings are contained within storage locations, allowing mapping changes from one database location to another without altering the project structure. Environments is a feature that is coming soon.

When configuring the User Connection and linking it to a Transformational project, a Default Location called "My Location" is automatically created.

- Click on the blue SqlDBM menu at the top left of the screen.

- Select "Settings and Conventions".

- Next, select "Storage Locations".

- A list of available Storage Locations will be shown.

- Here, the Name, Database, and Schema can be modified.

- Alternatively, new Locations can be configured.

- The default location can be changed if multiple locations are available.

- There must always be at least one location designated as default.