Forum Discussion

DPeaco's avatar
DPeaco
Moderator
6 months ago

NBUITA - Connecting with Oracle SQL Developer

Is there a way I can connect to NBUITA with Oracle SQL Developer so I can get a GUI view of the database structures in nbuita so it could be easier to build custom reports easier without all the gues...
  • Deeps's avatar
    Deeps
    6 months ago

    DPeaco Launch the SQL Developer > Click on the Green Plus sign on the left top corner to add a new connection.

    On the New / Select Database Connection screen, fill in the following details.

    Name : Give a name to the connection
    Username: portal
    Password: portal
    Hostname : Give the hostname OR IP address of the DB host, typically the portal host
    Service name: scdb

    Click Test to test the connection.

    If successful, click on connect 

     

     

     

     

     

     

DPeaco's avatar
DPeaco
Moderator
6 months ago

Robert_Geller 

Thanks, I will go check that out. Was asking about Oracle SQL Developer to build and test queries while learning this stuff. Like you, I  wear many different "hats" and my focus time is limited for tinkering with NBU ITA. Is there a How-To doc for connecting SQL Developer to NBUITA?