Description
The Data Destinations page under Settings is used to define how data can be automatically exported from the CopperCube. You can send the data to the CopperTree Kaizen servers and/or a local SQL server.
Send Data to CopperTree Servers
This configuration enables the transmission of Trend Logs, BACnet objects, events, and device backups to the CopperTree Kaizen servers. To enable the transmission, perform the following steps:
- This step can be done ahead of time to prepare Kaizen to receive the data. See the Kaizen reference for more details. Log into Kaizen, create the building and map the CopperCube to it using the site names and devices ranges that you will use in CopperCube. This process can take upto an hour to synchronize to transfer data from CopperCube to Kaizen.
- When Onsite (with cube connected to BACnet network), follow the following steps:
- Ensure the CopperTree Kaizen servers are set up before you start this procedure.
- Open the CopperCube web interface and log-in (For more info, see how to log-in)
- Browse to the Settings menu and select the Data Destinations item. This will open the Data Destinations page.
- Check the Enable CopperTree Intake Server check box.
The CopperTree Intake Server field should already display the correct server address of intake1.coppertreeanalytics.com. Click Update Intake Server to save changes.
- Database Save Time – This is when the controller databases are saved to Kaizen.
- Database Save Day of Week – This is the day of the week when the controller databases are sent to Kaizen. Disabled and every day are options.
- Object Fetch Time – This is when the BACnet objects are saved to Kaizen. The times for databases and objects are different to accommodate large networks and reduce congestion.
Kaizen saves the BACnet objects on a daily basis, controller databases will also be saved on a daily basis but only if changes are made to the controller databases. If no changes are made, the objects and databases are saved and sent on a schedule set by these fields. You usually do not have to change the default settings.
Send SQL Connector Configuration
This configuration enables the transmission of Trend Log data to an external SQL server. An SQL server needs to be set up and a database created prior to enabling the features on this page (for further information about the SQL Connector, please click here).To enable the transmission, perform the following steps:
- Open the CopperCube web interface and log-in (How to Log-in)
- Browse to the Settings menu and select the Data Destinations option. This will open the Data Destinations page.
- Select the SQL Connector checkbox to enable it. This will then show the transmission configuration for the SQL Connector.
- Enter the data for the following parameters:
- SQL Type – From the drop-down list, select the type of SQL database server used. Currently, only MySQL, Microsoft MS-SQL, and PostgreSQL servers are supported.
- SQL Server – Enter the IP address or DNS name of the server where the SQL database system is located.
- SQL Port – Enter the port number used to connect to the SQL server.
- Username and Password – Enter the login information needed to access the SQL server. This must be an admin account with permission to create/update/ drop databases, tables, and rows within the schema.
- Database Name (Schema)
- Click Update SQL to save changes.
- To verify the connection information is correct, click on the Test Connection button. A message will appear if the CopperCube was able to connect to the SQL server.
To disable the server connection, clear the SQL Connector Enable/Disable checkbox.
Changing Site Name
When the site name is changed, the existing tables will not be renamed nor updated. Instead, a new table with the new site name is created and the samples are collected after the last sample in the old table (with the old name). No data will be lost as sequence numbers will be consecutive but spread over 2 tables.
