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