Database Connections

If you are configuring the Lingk Adapter to connect directly to your database using queries, views or stored procedures, you will need to configure your database connections.

For this configuration, you will be editing the DBCPConnectionPool Controller Service which is available by clicking on "Gear" icon on the panel to the left of the main API flow template in Apache Nifi.

After configuration and enabling the service, click the ">" (Play)" button in same panel to see all the Red (stopped) processors turn Green (running).

Configure your database driver

  • Oracle (for PeopleSoft Campus Solutions and Banner by Ellucian)
    • Location
      extras/files/drivers/ojdbc6.jar
    • Class Name
      oracle.jdbc.driver.OracleDriver
  • Postgres
    • Location
      extras/files/drivers/postgresql-9.4.1212.jar
    • Class Name
      org.postgresql.Driver
  • Microsoft SQL Server
    • Location
      extras/files/drivers/mssql-jdbc-6.2.2.jre8.jar
    • Class Name
      com.microsoft.sqlserver.jdbc.SQLServerDriver
  • Other JDBC providers
    Add other JDBC drivers to the "drivers" directory and get their class name.

Configuring Database Connectivity

Oracle

Here are the instructions for an Oracle database.

1. Open the Main Flow configuration dialog as shown below.

2. Click on the pencil bolt icon for DBCPConnectionPool Controller Service

Note: You may also need to enable the StandardHttpContextMapPort3000 controller service, if it is disabled.

3. Enter your JDBC connection string, username and password into the Lingk Adapter processor 

Oracle Connection Strings Examples

Oracle connection strings (Service Name)

jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename
jdbc:oracle:thin:@//myhost:1521/myservicename
jdbc:oracle:thin:@myhost:1521/myservicename

Example connection string (SID)

jdbc:oracle:thin:@myhost:1521:ORCL

For more information on Oracle Connection strings go to: https://docs.oracle.com/cd/B28359_01/java.111/b31224/jdbcthin.htm

Postgres Connection Strings Examples

Microsoft SQL Server Connection String Examples

Example connection string (database user)

jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks

Example connection string (domain user)

jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks;integratedSecurity=true