Forum Discussion

DPeaco's avatar
DPeaco
Moderator
9 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 guessing of what database and what field in the database to use?

Please advise.

  • Deeps's avatar
    Deeps
    8 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
    8 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?

  • Deeps's avatar
    Deeps
    Level 6
    8 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