Setup Realtime Reporting Connector

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

Change directory to cim-solution/kubernetes/cim/Configmaps
Open realtime reporting connector configmap. ef-realtime-reporting-configmap.yaml.
CODE
```
vi ef-realtime-reporting-configmap.yaml
```
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