Welcome to the “SQL Databases” tutorial.
In this tutorial you’ll learn how to add and manage SQL databases in the CogBI Server. To display your data on an iOS device the CogBI app connects to the CogBI Server using an internet connection. The CogBI Server in a lightweight application that runs on Microsoft Windows computers and that lives in your offices. The CogBI server will connect to your SQL databases and run queries against them to retrieve the data that it sends to the CogBI iOS app. The following diagram illustrates how the process works:
Below you will find the necessary information on how to:
Open and Log In to the CogBI Web Administrator by launching it from the CogBI Service Monitor or by typing the Host Name/IP Address that you assigned to the CogBI Server directly in a browser:
Click on the SQL Database tab located in the main toolbar:
Click on ‘Add Database’:
Enter a nickname to identify the database you’re adding, then enter the connection string that should be used to open a connection to it and finally click on ‘Save Changes’:
The CogBI Server will attempt to connect to your database according following the parameters included in the connection string you entered. If successful, it will display a success message and add the newly created database connection to your database list:
Congratulations! You’ve successfully added a database to the CogBI Server and you may now start add SQL queries in order to send data to your iOS device.
To edit on of your SQL Databases you can click on the edit button next to them:
Here you can change the nickname that you use for the database. You can also modify the connection string by clicking on the ‘Show Connection String’:
For security reasons you’ll be asked to enter your password every time you wish to view or modify the connection string:
After entering your password you will be able to view and/or edit the connection string. After you’re finished click on the ‘Save Changes’ button if you wish to save your changes.
After saving your changes you’ll receive a confirmation message and and you will be returned to the database list:
To delete a database from the CogBI Server click on the ‘Edit Button’ next to the database you wish to delete:
Click on ‘the Delete Database’ button and confirm your action by clicking on the ‘Delete’ button in the next screen:
You will receive a confirmation message when the database is deleted:
This covers the management of SQL Databases in the CogBI Server. Continue learning about CogBI using the sidebar or the buttons below to navigate the support section.