Connecting an Oracle Database
Connect to Oracle

Here is what you need to connect:
- Read-only user (Username field)
- Credentials
- Oracle System ID (SID)
Create an Oracle read-only User
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

Create an Oracle Datasource in bipp
-
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
Sign up for a forever free account!
Connect to leading SQL databases
Build visual data models without learning a new language
Create two dashboards and ten reports for free