5.12.0 5.11.0 5.10.0 5.9.0 5.8.0 5.7.0 5.6.0 5.5.0 5.4.0 5.3.0 5.2.0 5.1.0 5.0 4.10 4.9 4.8 4.7 4.6 4.5.3 4.5.2 4.5.1 4.5 4.4 4.3
5.12.0 5.11.0 5.10.0 5.9.0 5.8.0 5.7.0 5.6.0 5.5.0 5.4.0 5.3.0 5.2.0 5.1.0 5.0 4.10 4.9 4.8 4.7 4.6 4.5.3 4.5.2 4.5.1 4.5 4.4 4.3
Breadcrumbs

Setup Realtime Reporting Connector

Realtime reporting connector supports MSSQL and MYSQL based connections. To configure as per your reporting database , adjust the configurations below.

  1. Change directory to cim-solution/kubernetes/cim/Configmaps

  2. Open realtime reporting connector configmap. ef-realtime-reporting-configmap.yaml.

    vi ef-realtime-reporting-configmap.yaml

  3. Edit the configs as per your deployment type.

Keys

MYSQL

MSSQL

DATASOURCE_URL

jdbc:mysql://<IP>:<port>/<databaseName>


Example:
jdbc:mysql://192.168.1.182:3306/cim_etl_report

jdbc:sqlserver://<IP>:<port>;databaseName=<dbName>;encrypt=false

Example: jdbc:sqlserver://192.168.1.77:1433;databaseName=cim_etl_report;encrypt=false

### set encrypt to true if your mssql db has TLS encryption enabled.

DATASOURCE_CONNECTION_TYPE

mysql

mssql

DATASOURCE_USERNAME

Example:
12345

Example:
12345

DATASOURCE_PASSWORD

Example:
root

Example:
root

DATASOURCE_DRIVER_CLASS_NAME

com.mysql.cj.jdbc.Driver

com.microsoft.sqlserver.jdbc.SQLServerDriver