To set the database connection, click on the settings, then on the database settings tab. Basic Reporter is able to display and receive data coming from Powerlogic SMS software, Powerlogic ION Enterprise software, logging stored in EGX300 Ethernet gateway devices,  databases of other systems (through ODBC connection) and individual devices using custom driver plug-ins (MODBUS, through FTP connection etc.). You can define the data source on the settings tab (Database settings).

 

 

 

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 OK.

 

 

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