License Warning on Startup

If you start Datical DB and a license is not installed, a warning is shown. 

Click OK to dismiss the warning. You can proceed to work in the GUI, but you cannot connect to databases until you install a license. 

Installing a License

1. Obtain a license file from Datical Support and place it on the system where you are running an instance of Datical DB. 
2. Start Datical DB. Dismiss the license warning (click OK). 
3. In the GUI, choose File > License Manager. 
4. Select the type of license to install, then click Next.
   
   
   
5. Choose (Re)Install a license key, the click Next. 
   
    
6. Use the browser to choose the license file. 
   
   
   
7. Click Finish. 

Displaying a License Key

You can display the license key installation date and expiration date, as well as details about the license.

1. Start Datical DB.
2. In the GUI, choose File > License Manager. 
3. Select the type of license to display, then click Next.
   
   
   
4. Choose Display the installed license key, the click Next. 
   
   
   
5. Review the license information. Click Finish when done. 
   

Counting Licensed Objects

Datical DB is licensed by the number of DbDefs managed in a database object. The object licensed depends on the type of database. 

• Oracle - per instance
• SQL Server - per database
• EDB Postgres - per database
• DB2 LUW - per database

License counting is a routine part of verifying the number of database connections (DbDefs) that you are managing, compared to the number that you are licensed to manage. 

The license counter reports on the projects that are installed on a host by inspecting the project files.  

When you run the license counter, specify a starting directory.  It walks the file system from that point down and reports on all project files that are found in the hierarchy. 

To count licenses, do the following: 

1. Log on to a host where you have created Datical DB projects. 

2. Run the license counter. The output goes to stdout, so provide a redirection to a file. 

   Linux:   hammer licenseCounter ~/datical > DaticalLicenseCount.txt
    
   Windows: hammer.bat licenseCounter C:\Datical\Projects > DaticalLicenseCount.txt

3. Inspect the license file to determine the number of licenses in use on the host. The following example shows the format of the report. 

   DB2:
   jdbc:db2://192.168.156.21:50000/int_db
   jdbc:db2://ec2-35-175-43-211.compute-1.amazonaws.com:50000/REFDB
   Total Unique DB2 Databases: 2
   
   Oracle:
   jdbc:oracle:thin:@localhost:1523/orclsid
   jdbc:oracle:thin:@192.168.156.21:1521/orcl
   jdbc:oracle:thin:@localhost:1521/orcl.shusak.com
   jdbc:oracle:thin:@localhost:1523:orclsid
   jdbc:oracle:thin:@localhost:1521:orcl
   jdbc:oracle:thin:@localhost:1521/orcl
   Total Unique Oracle Databases: 6
   
   MSSQL:
   jdbc:sqlserver://localhost\MSSQLEXPRESS:1433;databaseName=AdventureWorks2014
   jdbc:sqlserver://localhost\SQLEXPRESS:49818;databaseName=mydb2
   jdbc:sqlserver://localhost\SQLEXPRESS:49818;databaseName=mydb
   Total Unique MSSQL Instances: 2
   Total Unique MSSQL Databases: 3
   
   Total Instances Managed: 10
   Total Databases Managed: 11