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