Setup Kyubit Metadata Database
All OLAP analyses, reports, dashboards, and SQL queries created within the Kyubit BI tool are stored in a centralized internal database (default name: 'KyubitAnalysisDB').
During the initial installation, you will be prompted to provide details for the
MS SQL Server instance. This database serves as the repository for all metadata, including
KPI definitions and user permissions. You can customize the database name to fit your organization's naming conventions.
- SysAdmin Rights: The credentials provided during this specific step are used strictly for the initial database creation and schema setup.
- One-Time Use: These elevated privileges are not stored. For subsequent application operations, a standard service account is used as defined in the environment planning section.
Maintenance & Disaster Recovery
- Regular Backups: Always maintain a current backup of your internal database to ensure seamless disaster recovery for your SSAS reporting solution.
- Migration: By utilizing backup/restore procedures along with minor configuration settings adjustments, you can easily migrate your Kyubit environment to a new server.
For more information on licensing and data management, see our
BI Tools FAQ.