Note: The Kepion system database contains all your Kepion system settings. Its default name is Kepion_System but was CPMAppHost before Kepion version 6.1.22257 released.
Introduction
In this article, we'll take a look at the tables in your instance of our software and how you can edit them. Reconfiguring some of these tables might be necessary for you to get the most out of our software.
Note: You must use SQL Server Management Studio (SSMS) to access and edit the following tables.
Key tables
The following tables likely contain most, if not all, of the information you might want to review or edit.
dbo.Applications
The dbo.Applications table lists all of your Kepion solutions. Solutions refer to a project at its highest level—i.e., they contain all the individual Apps designed for your business or employer. When you create an application, you generate a new SQL database with its own data, configurations, and settings.
| Setting | Function |
|---|---|
| Description | You can edit this field via the Kepion Modeler. Click Application on the right menu, type your desired description in the Description box, and click the Save icon. |
|
ConnectionString |
Default SQL Server Connection String. |
| OlapConnectionString | Template OLAP uses to connect to SQL |
| ManagedOlapProvider | (For internal use) Option to designate a specific provider for the connection string from the Web Server to SSAS. |
| OlapProvider | (For internal use) Option to specify a provider between SQL and SSAS. |
| OlapServers | List of servers. Having only one is recommended, but you can set up more. |
| Category | You can edit this field via the System tab in Kepion. Go to an Application, fill in the Category field, and click the Save icon. |
| SQLEdition | Either Standard or Enterprise (cell appears blank) |
| IsManagedCache |
If you are running Standard edition SQL, you will see 1. That means we are handling pro-active caching.
If you are running Enterprise edition SQL, you will see a 0. SQL handles pro-active caching in the Enterprise edition. |
| State | Online (1) or Offline (2) |
* Any setting not mentioned above is self-explanatory.
dbo.Authentication
The dbo.Authentication table lists the user authentication options you've set up for your Kepion environment. Our software supports a number of standard Windows authentication methods, as well as Active Directory Federation Services (ADFS) and Azure Active Directory (Azure AD).
To learn how you can add or remove authentication options, follow this guide.
dbo.SystemAdmins
The dbo.SystemAdmins table, as the name suggests, lists all the of the sysadmins in your Kepion environment.
If you have sysadmins authenticated through Azure, you can see their credentials under the Azure Object ID (maps Kepion user to Azure) and User Principal Name (Azure username) columns.
Tip: If you are missing the System tab in Kepion, refer to this article.
dbo.SystemSettings
The dbo.SystemSettings table can be divided into three categories:
- Default system settings
- System configurations in Kepion
- Internal Kepion settings
| Setting | Function |
|---|---|
| AppHostInstanceId | Internal ID for the app instance. |
| AutoUserAdd | Internal settings for adding users automatically |
| DefaultAppDBConnectionStringFormat | Where the database is created when you first create an Application. |
| DefaultAppDBOlapConnectionStringFormat | Default location for OLAP databases |
| IsExpired | Turns Kepion on (0) and off (1) |
| SystemLocale | Language setting for server messages |
* Any setting not mentioned above is self-explanatory.
Ancillary tables
Users likely won't have any reason to check or edit the following tables. They are for internal use only.
dbo.Certificates
dbo.Certificates stores generated crypto security certificates used for signing auth tokens. This table stores the certificate (with private key) and metadata explaining the certificate's use.
dbo.RobustRequests
dbo.RobustRequests logs your actions to ensure they get executed. An unstable connection, for instance, will not erase whatever work you have done.
dbo.Requests
dbo.Requests is a deprecated version of dbo.RobustRequests.
dbo.SystemHealth
dbo.SystemHealth tracks client issues, bugs, etc.
dbo.SystemLoginMapping
dbo.SystemLoginMapping maps login information.
dbo.Version
The dbo.Version table just shows what version of Kepion you have running on your machine and when you last downloaded/updated the software. If you don't have the latest version of Kepion, you could be missing out on major features. Follow our Announcements page to remain informed of any updates and also check out our update guide if you need assistance with getting the newest version of our software.