Connecting to the Database

Having set up a connection, you can then open the connection, supply your login credentials, and then begin issuing queries against the database.


Procedure 3.13. To open a connection:

  1. Double click the connection in the Connections view. Alternatively, you can right-click a connection and select "Connect".

    Figure 3.20. Connecting to the Platform database.
    images/download/attachments/144835026/studio_62-version-1-modificationdate-1645038802000-api-v2.png

  2. You are prompted for your database login credentials, which should be filled in for you. There is a check box to indicate whether you want statements to automatically commit. This is normally checked.

    Figure 3.21. Logging in to the Platform database.
    images/download/attachments/144835026/studio_63-version-1-modificationdate-1645038809000-api-v2.png

  3. Click OK. The Database Structure tab appears, and the Connections tab indicates an active database session.