View source for Help:Octofy: Manage data sources

[[Category:Octofy]]
[[File:Octofy_Data_source_manage.png|400px|thumb|right|Manage data source screen]]
==Change the settings of a data source==
To manage the data sources you added to the system, click on the "Manage DB connections" menu item from the File menu. The "Manage Connections Dialog" will pop up.
*Select the data source item in the Connections list box.
*Edit and change the name of the data source in the Name text box.
*Enter the server name in the Server name text box if you want to connect to a different database server.
*Enter or select database name from the Database name combo box.
*Select the authentication type to log on to the server
*Enter User name and password if SQL Server Authentication has been select.
**Check the Remember password check box if you want the system to remember the password.

===Connection to a SQL server using a different port===
If the target SQL server using a different port other than the default 1433, you can type the server name into the Server name text box follows by a comma then the port number. For example "mydb.database.windows.net,14330" where mydb.database.windows.net is the database server name and 14330 is the port number.

==Add a new data source==
You can add a new data source from this dialog as well. To add a new data source, click on the "New" button and repeat the steps as same as [[#Change the settings of a data source]]

==Delete a data source==
To delete a data source:
*Click on the data source item in the Connections list box.
*Click on the Delete button
*Click on the OK button to confirm the deletion.

==Test a data source connection==
You can select a data source item from the Connections list box and click on the Test to ensure the database connection works.

</br>
----
Back to [[Help:Octofy: User Manual|Octofy User Manual]]