Connecting an Oracle Database
Here is what you need to connect:
- Read-only user (Username field)
- Oracle System ID (SID)
bipp recommends using a read-only user for connecting to your Oracle databases.
Using a SQLPlus command line:
$ sqlplus / as sysdba SQL> CREATE USER bipp_db_user IDENTIFIED BY "Secret@123"; User created. SQL> GRANT CREATE SESSION TO bipp_db_user; Grant succeeded. SQL> GRANT READ ON your_database.your_table TO bipp_db_user; Grant succeeded. SQL> exit
Select Datasources from the Home Navigation pane to open the Datasources page.
Click New Datasource on the Datasources page.
Enter a Name. For example, TestOracle.
Select Oracle for SQL Dialect for your database. bipp creates and enforces the rules for the selected dialect.
Enter the information for your Oracle database instance:
- Host: name or IP address of the database host.
- Port: port on the host for the connection.
- Username: user name for the connection. bipp recommends using a read-only user account.
- Password: password for the user.
- ServiceName: Oracle System ID (SID) used to uniquely identify the particular database. The SID is case sensitive in UNIX/Linux environments.
Click Test to verify the datasource connectivity. If you have an error, fix the connection or credentials problem and click Test again.
Click Create to add the datasource.
Congratulations! You have successfully created an Oracle datasource in bipp.
IN THIS PAGE