Apache NiFi -> Oracle cloud database

필요 정보: 

 

docker-compose file

version: '3.1'

services:
  nifi:
    container_name: nifi
    image: apache/nifi:latest
    restart: always
    environment:
      NIFI_WEB_HTTP_PORT: 9095
      NIFI_JVM_HEAP_MAX: 8196m
      NIFI_WEB_PROXY_HOST: 192.168.0.5:9095
      TZ: Asia/Seoul
      NIFI_REMOTE_INPUT_SECURE: false
      TNS_ADMIN: /opt/nifi/nifi-current/lib/wallet
      JAVA_OPTS: -Doracle.net.tns_admin=/opt/nifi/nifi-current/lib/wallet
    volumes:
      - nifi-conf:/opt/nifi/nifi-current/conf
      - nifi-state:/opt/nifi/nifi-current/state
      - nifi-content:/opt/nifi/nifi-current/content_repository
      - nifi-database:/opt/nifi/nifi-current/database_repository
      - nifi-flowfile:/opt/nifi/nifi-current/flowfile_repository
      - nifi-provenance:/opt/nifi/nifi-current/provenance_repository
      - nifi-libraries:/opt/nifi/nifi-current/lib
    ports:
      - 9095:9095 # for UI

volumes:
  nifi-conf:
  nifi-state:
  nifi-content:
  nifi-database:
  nifi-flowfile:
  nifi-provenance:
  nifi-libraries:

networks:
  default:

 

NiFi Database - DBCPConnectionPool

1. Database Connection URL

jdbc:oracle:thin:@(description=(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=asdfasdf))(connect_data=(service_name=asdfasdfsdafasdf))(security=(MY_WALLET_DIRECTORY=/opt/nifi/nifi-current/lib)))

 

2. Database Driver Class Name

oracle.jdbc.OracleDriver

 

3. Database Driver Location(s)

/opt/nifi/nifi-current/lib/ojdbc8.jar,/opt/nifi/nifi-current/lib/oraclepki-19.3.0.0.jar,/opt/nifi/nifi-current/lib/osdt_cert-19.3.0.0.jar,/opt/nifi/nifi-current/lib/osdt_core-19.3.0.0.jar

 

Additional Properties (in the "Advanced" tab):

• oracle.net.ssl_server_dn_match = true
• oracle.net.ssl_version = 1.2
• oracle.net.tns_admin = /opt/nifi/nifi-current/lib/wallet