Load Project

Load Project

The Load Project command imports a complete repository configuration from a structured folder system into AnalyticsCreator.

This feature is essential for restoring previous model states, migrating configurations between environments, and integrating version-controlled changes back into your workspace.

Icon	Feature	Description
	Load project	Imports a complete repository configuration from a structured folder system previously created by Save project.

Overview

Load project enables you to restore an entire data warehouse model from a folder-based export. This is particularly useful when:

• Migrating configurations between development, testing, and production environments
• Restoring a previous version from version control systems (Git, SVN, etc.)
• Sharing repository templates with team members
• Recovering from a Backup & Restore file that was extracted to folders
• Integrating changes from other developers' branches

Unlike the single-file backup format, the folder structure allows you to inspect individual object definitions before importing and enables granular version control tracking.

Prerequisites

• A valid project folder structure created by AnalyticsCreator (containing subfolders like Connectors, Sources, Tables, etc.)
• Appropriate permissions to access the target repository database
• Recommended: Synchronize existing metadata before loading to avoid conflicts
• The folder structure must be complete - missing required folders may result in incomplete imports

Using Load Project

To launch the Load project dialog, click the "Load project" button in the Project section of the toolbar.

1. Click the Load project button in the ribbon
2. Browse to the root folder of the exported project (e.g., Northwind_Demo)
3. Select the folder containing the subdirectories (Connectors, Sources, Tables, etc.)
4. Click "Open" to begin the import process
5. AnalyticsCreator will validate the folder structure and load all metadata objects into the current repository

Import Behavior

During the import process:

• Existing Objects: If an object with the same name exists, it will be updated with the imported definition
• New Objects: Objects not present in the current repository will be created
• Dependencies: The import automatically resolves relationships between objects (e.g., table references, source mappings)
• Validation: AnalyticsCreator validates object integrity and reports any missing dependencies or corrupted files

Best Practices

• Backup First: Always create a backup of your current repository before loading a project, especially in production environments
• Sync Before Load: Run Sync DWH before importing to ensure your current metadata is up to date
• Environment Check: Verify you are connected to the correct environment before loading (Dev, Test, or Prod)
• Partial Imports: If you only need specific objects, consider importing via Backup & Restore with selective objects instead
• Version Tags: When working with Git, check out specific tags or commits before loading to ensure you are importing the correct version

Troubleshooting

Load Project

The Load Project command imports a complete repository configuration from a structured folder system into AnalyticsCreator.

This feature is essential for restoring previous model states, migrating configurations between environments, and integrating version-controlled changes back into your workspace.

Icon	Feature	Description
	Load project	Imports a complete repository configuration from a structured folder system previously created by Save project.

Overview

Load project enables you to restore an entire data warehouse model from a folder-based export. This is particularly useful when:

• Migrating configurations between development, testing, and production environments
• Restoring a previous version from version control systems (Git, SVN, etc.)
• Sharing repository templates with team members
• Recovering from a Backup & Restore file that was extracted to folders
• Integrating changes from other developers' branches

Unlike the single-file backup format, the folder structure allows you to inspect individual object definitions before importing and enables granular version control tracking.

Prerequisites

• A valid project folder structure created by AnalyticsCreator (containing subfolders like Connectors, Sources, Tables, etc.)
• Appropriate permissions to access the target repository database
• Recommended: Synchronize existing metadata before loading to avoid conflicts
• The folder structure must be complete - missing required folders may result in incomplete imports

Using Load Project

To launch the Load project dialog, click the "Load project" button in the Project section of the toolbar.

1. Click the Load project button in the ribbon
2. Browse to the root folder of the exported project (e.g., Northwind_Demo)
3. Select the folder containing the subdirectories (Connectors, Sources, Tables, etc.)
4. Click "Open" to begin the import process
5. AnalyticsCreator will validate the folder structure and load all metadata objects into the current repository

Import Behavior

During the import process:

• Existing Objects: If an object with the same name exists, it will be updated with the imported definition
• New Objects: Objects not present in the current repository will be created
• Dependencies: The import automatically resolves relationships between objects (e.g., table references, source mappings)
• Validation: AnalyticsCreator validates object integrity and reports any missing dependencies or corrupted files

Best Practices

• Backup First: Always create a backup of your current repository before loading a project, especially in production environments
• Sync Before Load: Run Sync DWH before importing to ensure your current metadata is up to date
• Environment Check: Verify you are connected to the correct environment before loading (Dev, Test, or Prod)
• Partial Imports: If you only need specific objects, consider importing via Backup & Restore with selective objects instead
• Version Tags: When working with Git, check out specific tags or commits before loading to ensure you are importing the correct version

Troubleshooting