![[2020-03-17] 아파치 나이파이(Apache nifi)이용 MSSQL연결](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FcyL9p8%2FbtqCM88h1tO%2FKuQPVwVHOeqykMzp6IXgm0%2Fimg.png)
1. connector 다운로드
https://osdn.net/projects/sfnet_id2d/downloads/jdbc%20drivers/sqljdbc4.jar/
Downloading File /jdbc drivers/sqljdbc4.jar - id2d - OSDN
Free download page for Project id2d's sqljdbc4.jar.The project provides programming method to transfer data within Oracle, IBM DB2, Sybase, Microsoft SQL Server and MySQL databases. It wrote by...
osdn.net
2. apache nifi에서 사용할 Processor 생성
3. Processor의 configure에서 관련 설정
(1) Database Connection Pooling Service : DBCPConnectionPool
4. DBCPConnectionPool의 Go to이동
(1) Database Connection URL : jdbc:sqlserver://[DB서버 주소]:1433;databaseName=[DB명]
(2) Database Driver Class Name : org.mariadb.jdbc.Drivercom.microsoft.sqlserver.jdbc.SQLServerDriver
(3) Database Driver Location(s) : [다운로드한 jar경로]
(4) Database User : [접속 계정]
(5) Password : [접속 계정 비번]
5. 번개 표시를 눌러 해당 Service활성화
'System > 작업LOG' 카테고리의 다른 글
| [2020-05-20] centos8 - Keepalived 설치/설정 (2) | 2020.05.20 |
|---|---|
| [2020-03-24] 아파치 나이파이(Apache nifi)이용 DB 1:1 데이터 이동 (4) | 2020.04.09 |
| [2020-03-17] 아파치 나이파이(Apache nifi)이용 MariaDB연결 (0) | 2020.03.26 |
| [2020-03-03] 아파치 나이파이(Apache nifi) 설치 (0) | 2020.03.16 |
| [2020-02-19] CentOS-MariaDB MHA 원복하기 (0) | 2020.03.03 |