Configuration of BIRT Analytics FastDB (dubnium)
BIRT Analytics FastDB engine, also referred to as the dubnium engine, is a web-based, Extract, Transform, and Load (ETL) service that reads most data sources. After installing FastDB, the administrator can change the default settings in the engine_configuration.ini file.
In Windows, the engine_configuration.ini file is in the following default location:
C:\Program Files\Actuate\BIRTAnalytics\dubnium
In Linux, the engine_configuration.ini file default location is:
/etc/dubnium
Listing 2‑5 shows the default Windows engine_configuration.ini code installed with the product.
Listing 2‑5 engine_configuration.ini code
[engine]
license = C:\Program Files\Actuate\BIRTAnalytics\dubnium\dubnium.lic
repository = C:\Program Files\Actuate\BIRTAnalytics\dubnium\databases
 
[log]
path = C:\Program Files\Actuate\BIRTAnalytics\dubnium\log\engine.log
verbosity = 6
 
[server]
admin_file_path = C:\Program Files\Actuate\BIRTAnalytics\dubnium
\admin.sqlite
Table 2‑5 lists the engine_configuration.ini parameters and describes their function. In the file specification, except for the generic options, group each parameter under its appropriate option tag, such as [engine], [log], or [server], omitting the option tag prefix, as shown in the Table 2‑5 examples.
In Table 2‑5, the example indicates the default setting. It is not necessary to specify a parameter in the engine_configuration.ini unless you want to change the default value.
Table 2‑5 BIRT Analytics FastDB engine_configuration.ini parameters
Parameter
Description
 
Generic options.
help
Show help.
register_service
Register this binary in services (Windows only).
unregister_service
Remove this binary in services (Windows only).
setpkpass
Prompt for a private key password to store in the configuration file.
version
Show version information.
config
Configuration file.
For example, config =engine_configuration.ini.
[engine]
Engine options.
engine.license
License file.
For example, engine.license = dubnium.lic.
engine.repository
Engine repository path.
For example, repository = databases.
engine.autocleanup
Automatic cleanup.
For example, autocleanup = 0.
engine.autoregenerate
derived
Automatic regeneration of derived columns.
For example, autoregeneratederived = 1.
engine.locale
System wide locale.
For example, locale = en_US.
engine.cxcachepagesize
Crosstab page size.
For example, cxcachepagesize = 10000.
engine.defaultformatdate
Date default format.
For example, defaultformatdate = yyyymmdd.
engine.defaultformat
datetime
Time and date default format.
For example, defaultformatdatetime = yyyymmdd_hhMMss.
engine.defaultformattime
Time default format.
For example, defaultformattime = hhMMss.
engine.defaultformatreal
Real (floating point) number default format.
For example, defaultformatreal = .
engine.defaultpagesize
Default page size.
For example, defaultpagesize = 100.
engine.defaultprecision
Default decimal precision.
For example, defaultprecision = 2.
engine.maximumprecision
Maximum decimal precision.
For example, maximumprecision = 8.
engine.firstdiscrete
threshold
Domain count to change strategy in first discrete operation.
For example, firstdiscretethreshold = 1024.
engine.autolinkjumps
Number of jumps accepted before creating a new link automatically. For example, autolinkjumps = 1.
engine.nonlinked
_aggregated
Crosstabs non-linked record values are aggregated in a row.
For example, nonlinked_aggregated = 0.
engine.max_pivot_values
Crosstabs max discrete values in a pivot column.
For example, max_pivot_values = 1024.
[log]
Log options.
log.path
Log path.
For example, path = engine.log.
log.verbosity
Log verbosity specifies level of detail.
For example, verbosity = 6.
[memory]
Memory options.
memory.maxmemory
system
Maximum system memory in megabytes. Estimate the maximum value using the following formula:
[Server memory] - ([OS memory] * 2
For example, maxmemorysystem = 4096.
memory.maxmemory
thread
Maximum thread memory in megabytes. Each engine request uses a separate thread. For example, maxmemorysystem = 2048.
Total memory usage for threads cannot surpass maxmemorysystem. Set the value for maxmemorythread according to the number of predicted concurrent requests.
memory.memorylog
enabled
Memory log enabled.
For example, memorylogenabled = 1.
memory.buffer_size
_datasources
Datasources buffer size in kilobytes.
For example, buffer_size_datasources = 8192.
[rdp]
Remote data provider (RDP) options.
rdp.use_proxy
Use proxy to connect to source.
For example, use_proxy = 0.
rdp.proxy_type
Proxy type:
*HTTP
*HTTP_1_0
*SOCKS4
*SOCKS5
*SOCKS4A
*SOCKS5_HOSTNAME
For example, proxy_type = HTTP.
rdp.proxy_addr
Proxy IP address.
For example, proxy_addr = 0.0.0.0.
rdp.proxy_port
Proxy port.
For example, proxy_port = 8080.
rdp.proxy_username
Proxy user name.
For example, proxy_username = username.
rdp.proxy_password
Proxy password.
For example, proxy_password = password.
rdp.proxy_exceptions
Comma separated list of hosts which do not use a proxy.
For example, rdp.proxy_exceptions = urup.
rdp.username
User name for server authentication.
For example, username = username.
rdp.password
Password for server authentication.
For example, password = password.
rdp.ssl_verify
Verify against certificate authority (CA).
For example, ssl_verify = 0.
rdp.ca_cert
Public certificate authority (CA) file.
For example, ca_cert =
rdp.connect_timeout
Connect time-out in seconds.
For example, connect_timeout = 30.
rdp.timeout
Regular time-out in seconds.
For example, timeout = 60.
[server]
Server options.
server.admin_file_path
Server administration file path.
For example, admin_file_path =
C:\BIRTAnalytics\dubnium\admin.sqlite.
server.connectiontimeout
Connection time-out (ms).
For example, connectiontimeout = 0.
server.maxrequestlen
Maximum request length.
For example, maxrequestlen = 65535.
server.threads
Maximum threads per server.
For example, threads = 5.
server.ssl_mode
Certificate mode for SSL:
*simple for self-signed certificate
*complete for root certificate authority (CA)
For example, ssl_mode = simple.
server.ip
Listener IP address.
For example, ip = 0.0.0.0.
server.port
Listener port for insecure connections. Set to 8105 by default.
For example, port = 8105.
server.secure_port
Listener port for secure connections. Set to 8106 by default.
For example, secure_port = 8106.
server.enable_insecure_port
Start insecure, standard port. Enabled by default.
For example, enable_insecure_port = 1.
server.enable_secure_port
Start secure, SSL port. Disabled by default.
For example, enable_secure_port = 0.
server.dh_filename
Diffie-Hellman parameters file.
For example, dh_filename = dhparams.pem.
server.rand_filename
Random file for SSL calculations.
For example, rand_filename = ssl.rnd.
server.certificate
Server public certificate.
For example, certificate = server.pem.
server.private_key
Server private key.
For example, private_key = server.key.
server.private_key
_password
Password for server private key.
For example, private_key_password = private key.
server.root_ca_certificate
Root certificate authority (CA) public certificate.
For example, root_ca_certificate = cacert.pem.
server.cert_country
Server certificate country as two-character data specification.
For example, cert_country = US.
server.cert_locality
Server certificate locality.
For example, cert_locality = New York.
server.cert_state
Server certificate state.
For example, cert_state = Texas.
server.cert_email
Server certificate contact e‑mail.
For example, scert_email =
administrator@yourdomain.com.
server.cert_organization
Server certificate organization or company name.
For example, cert_organization = Actuate.
server.cert_service_names
Server certificate separated service names.
For example, cert_service_names =
server.localdomain.com,192.168.0.55.
server.admin_file_path
Authentication and security file path.
For example, admin_file_path = admin.sqlite.
server.enable_dbfibrillator
Automated restart in case of crash.
For example, enable_dbfibrillator = 1.
server.enable_daemon
Daemon mode.
For example, enable_daemon = 0.
server.winsvc_user
Windows service registration username.
For example, winsvc_user = username.
server.winsvc_pass
Windows service registration username.
For example, winsvc_pass = password.