Setup Reporting Connector

Reporting Connector ConfigMaps

Create the the database in target Database Management System using the scripts from cim-solution/kubernetes/pre-deployment/reportingConnector/SQLScripts/dbcreation directory.
Update the "fqdn, browser_language, connection_type and Database server connection parameters" in the file pre-deployment/reportingConnector/reporting-connector.conf

Apply configuration for Reporting-Connector

kubectl -n expertflow create configmap ef-reporting-connector-conf --from-file=pre-deployment/reportingConnector/reporting-connector.conf

Reporting Connector MySQL SSL Configuration Optional Step

The 4.4 release, support the reporting components connection with MySQL on SSL. To configure the reporting connector with MySQL over SSL, consult MYSQL SSL Connection Configuration for Reporting.

You can specify the schedule for your cron job by setting the parameter schedule: "*/5 * * * *" in cim-solution/kubernetes/pre-deployment/reportingConnector/ef-reporting-connector-cron.yaml file where the value '5' is a default time which corresponds to the interval in minutes. Replace the value by replacing '5' with your specified minutes.
Apply the configuration defined in pre-deployment/reportingConnector/ef-reporting-connector-cron.yaml file by the below command to run cron job for reporting-connector.
```
kubectl apply -f pre-deployment/reportingConnector/ef-reporting-connector-cron.yaml -n expertflow
```

These steps will effectively deploy the Kubernetes cron job for the reporting connector in the specified namespace expertflow.