Drill-through Database Configuration
Traditional relational database management systems (RDBMS) might struggle when profiling drill-through storage (see Configure the Profiling Step) due to their limitations on row size and number of columns and functionalities not needed for drill-through, such as transactions and row-locking, joins and nested queries, incremented backup.
The drill-through database (DTDB) is designed to help remediate such issues. It is a simpler but much more efficient storage when it comes to drill-through features.
Configure DTDB
As a prerequisite, make sure Java 1.7+ is installed. |
To configure the DTDB:
-
Create an empty folder
dtdb_data
at the same location as the server configuration file. -
Turn on and configure the DTDB server component in the server configuration file:
<component class="com.ataccama.dqc.dtdb.server.DtDbServerComponent" folder="./dtdb_data" port="5103"/>
-
Start the DTDB by running the
start.bat
script in<ATACCAMA_HOME>/server
folder. -
Configure a connection to the DTDB using one of these options (select DTDB in the Database type field):
-
Fill in the database connection details as follows:
-
Host:
localhost
. -
Port: The port set in the DtDbServerComponent (for example, 5103).
-
Catalog name:
syscat
. -
Username:
sys
. -
Password:
sys
.
-
-
Use the URL connection string with the following parameters:
-
Connection string:
jdbc:dtdb:remote:localhost:5103;syscat
. -
Username:
sys
. -
Password:
sys
.
-
-
-
Connect to the DTDB, open it in the SQL Editor, and execute these functions:
Make sure to use single quotes ( '
) in functions.Function name Description createCatalog('newCatalog')
Creates new catalog 'newCatalog'.
useCatalog('newCatalog')
Uses new catalog 'newCatalog'.
createSchema('newSchema')
Creates new schema 'newSchema'.
updateUser('username', 'password')
Creates new user 'username' with password 'password'.
-
Redefine the connection to the DTDB to use the newly created catalog and user using one of these options:
-
Fill in the database connection details as follows:
-
Host:
localhost
. -
Port: The port set in the DtDbServerComponent (for example, 5103).
-
Catalog name:
newCatalog
. -
Username:
<username>
. -
Password:
<password>
.
-
-
Use the URL connection string with the following parameters:
-
Connection string:
jdbc:dtdb:remote:localhost:5103;newCatalog
. -
Username:
<username>
. -
Password:
<password>
.You have now established a working connection to the DTDB with the functional drill-through feature.
-
-
DTDB server component
The component enables a proprietary Drill-throuongh Database (DTDB) optimized for drill-through access to the profiling results. To add the component to ONE Runtime Server, add the following definition to the server configuration:
<component folder="./dtdb_data" port="5103" disabled="false" class="com.ataccama.dqc.dtdb.server.DtDbServerComponent"/>
Property | Default value | Required | Description |
---|---|---|---|
Folder |
|
Yes |
Relative (to the server configuration file) or absolute path to the target folder for storing the profiling results. The folder has to be created before you start the server. |
Port |
|
Yes |
Port used for connection to the DTDB.
If not specified, the default value |
Was this page useful?