Connection to a Database with ODBC


Open ModelSphere can establish an ODBC connection to a database with the JDBC-ODBC driver.


ODBC Data source

You have to define an OBDC Data source before configuring ModelSphere. To define an OBDC Data source, refer to the DBMS documentation.


Setting a driver

To establish the connection, go to the main menu and choose: Tools > Database >Connect.



1 - Create a new connection's setting by clicking on the New button and fill the name field for the next uses.

2 - Choose the ODBC option.

3 - Enter the ODBC data source name in the corresponding field.


Default username and password

You can define a default username and a default password for the connection. But those fields can be left empty, the username and the password will be asked during the process.


Connect

Once the setting is done, click on the Select button. A window will appear for confirmation of the username and password, those fields contain the default username and password. You can modify them if you need and confirm by clicking on the OK button.



Another window will appear, to confirm the connection status and showing its information.

To know if ModelSphere is connected, see if the database icon is active or not in the status bar.


Disconnect

To disconnect from a database, go in the main menu and choose: Tools > Database > Disconnect.


Connection Information

To see the connection information, go in the main menu and choose: Tools > Database > Show Connection Info...