Once the drivers for your database have been added and are visible in the Databases node, you can open a connection to the database.
Once the initial connection has been made you can do the following:
To open a new connection:
This URL typically begins with jdbc:and a short code name for the driver, followed by another colon. The rest of the URL depends on the type of driver you are using. For example, you might need to specify a host and port; alternatively, the name of a database file might suffice, or an ODBC DSN. For MySQL, the Database URL might look as follows:
jdbc:mysql://localhost:3306/mydatabaseTo help you get started, existing drivers are provided with templates for the correct URL format. If in doubt, refer to the documentation for the driver you are using.
The password is saved only for the current IDE session. After restarting the IDE, you must type the password again.
If the connection is successful, the database connection node appears as
a subnode of the Databases node. The database connection node appears whole (
)
indicating the database is connected.
When the database is connected, you can expand the database connection node to see the child folders
representing lists of tables, views and procedures.
For more, see Browsing Structures.
If the connection attempt fails, the IDE displays a dialog box indicating the connection is broken and the database connection node is broken. Check the connection information for the database and create a new connection.
To disconnect from the database:
You cannot browse the database until you reconnect to the database.