Skip to main content
Skip table of contents

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.

    CODE
    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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.