Foundation: Understanding Project Repositories
The TimeXtender software is what is known as an abstraction layer. It does not actually store any databases, tables, fields, or rows of data. It simply manages all of the metadata about these objects. TimeXtender displays visual representations of these objects in the user interface (UI). However, all the information about the projects, settings, connection strings, tables, relations etc you create in TimeXtender are all stored in a SQL Database known as the Project Repository.
When you save a project, metadata is written to the repository database, and when you open a project, this metadata is read from the project repository and presented in the UI.
This is in contrast to the Deployment & Execution process which moves data from sources into the ODX, MDW, and Semantic Models.
One project repository can contain multiple projects. In this section, one project environment and one global database are needed, which sets the foundation for your data estate solution.
TimeXtender provides you the flexibility to build out multiple data warehouse solutions with the convenience of having all of the metadata for these solutions stored in one location. Rather than store the data directly, TimeXtender manages all of the metadata about these objects. This design supports things like project import/export, version control, data lineage, documentation, and intelligent executions.
For more detailed information, please see Project Repositories.