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.
CODEvi 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:sqlserver://<IP>:<port>;databaseName=<dbName>;encrypt=false |
DATASOURCE_CONNECTION_TYPE | mysql | mssql |
DATASOURCE_USERNAME | Example: | Example: |
DATASOURCE_PASSWORD | Example: | Example: |
DATASOURCE_DRIVER_CLASS_NAME | com.mysql.cj.jdbc.Driver | com.microsoft.sqlserver.jdbc.SQLServerDriver |