Forum Discussion

DPeaco's avatar
DPeaco
Moderator
10 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.

  • 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 

     

     

     

     

     

     

  • 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?

  • 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