Important: In the data base setting window we can define from which data base we want to take the quantity variables and their value (Powerlogic or other SCADA systems, etc.). In case of survey of the Quantity variable the data base settings will be saved too. Each Quantity variable has its own data base setting parameter. When running the query, the Quantity parameters are automatically query the given values from the data base specified in their own data base connection parameter.

 

To set the database connection, click on the Settings, then on the Database settings tab. Business Intelligence is able to display and receive data coming through Powerlogic SMS softwares, Powerlogic ION Enterprise softwares, directly through EGX300 devices, through databases of other systems (through ODBC connection) and directly from field devices such as logging gateways, data concentrators, or PLC's (MODBUS, through FTP connection etc.). You can define the data source on the settings tab.

 

 

 

Datasource name:

 

You can define the computer name or IP address (example: 10.29.2.204\SMS3000 or konsys17\ION) and the SQL server name. When using EGX300 device, you only have to define the IP address.

 

Enquiry on the computer name with command ipconfig /all

 

SMS 4.0 PE system (computer name\SQL server name)

 

ION Enterprise computer and database name

 

Database name:

 

You can select database type according to the system to be connected.

 

Username:

 

You can define the login name to use to access the database.

 

Password:

 

You can define the password for the login name to access the database.

 

Upon defining the above mentioned, you will be able to make a test on the database connection (Connection test button), then click on Save.

 

Connecting to Powerlogic SMS systems

Connecting to Powerlogic ION systems

Connecting to an EGX300 device

Connecting to AVReporter database (attach to other systems)

Connecting to database has failed