Optional Requirements

Configuring AnalyticsCreator – Visual Guide (Canva) 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.
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. ⬅ Previous Page | ➡ Next Page