This guide will walk you through configuring AnalyticsCreator with your system.

Provide the Login and Password that you received by e-mail from AnalyticsCreator

Minimum Requirements

Configuration Settings

The configuration of AnalyticsCreator is very simple. The only mandatory configuration is the SQL Server Settings.

1. SQL Server Settings
   1. Use LocalDB to store repository: Enables you to store the AnalyticsCreator project (metadata only) on your LocalDB.
   2. SQL Server to store repository: Enter the IP address or the name of your Microsoft SQL Server.
   3. Security
      • Integrated: Authentication is based on the current Windows user.
      • Standard: Requires a username and password.
      • Azure AD: Uses Azure AD (now Microsoft Entra) for Microsoft SQL Server authentication.
      • Trust server certificate: Accepts the server's certificate as trusted.
   4. SQL User: The SQL Server username.
   5. SQL Password: The corresponding password.

Optional Requirements

1. Paths
   1. UNC path to store backup: A network path to store project backups.
   2. Local SQL Server path to store backup: A local folder to store your project backups.
   3. Local SQL Server path to store database: A local folder to store your SQL Server database backups.
   4. Repository database template: The alias format for your repositories. Default: repo_{RepoName}.
   5. DWH database template: The alias format for your DWH templates. Default: dwh_{RepoName}.
2. Proxy Settings
   1. Proxy Address: The IP address or hostname of your proxy server.
   2. Proxy Port: The port number used by the proxy.
   3. Proxy User: The username for proxy authentication.
   4. Proxy Password: The password for the proxy user.

Now you're ready to create your new Data Warehouse with AnalyticsCreator.