Apache Nifi | How do I create a connection to MS SQL Server

Please consider subscribing to get notifications when new video's are published.

Link to MS SQL Server jdbc Driver: https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15

Apache NiFi supports powerful and scalable directed graphs of data routing, transformation, and system mediation logic. Some of the high-level capabilities and objectives of Apache NiFi include:

Web-based user interface
    Seamless experience between design, control, feedback, and monitoring
Highly configurable
    Loss tolerant vs guaranteed delivery
    Low latency vs high throughput
    Dynamic prioritization
    Flow can be modified at runtime
    Back pressure
Data Provenance
    Track dataflow from beginning to end
Designed for extension
    Build your own processors and more
    Enables rapid development and effective testing
Secure
    SSL, SSH, HTTPS, encrypted content, etc...
    Multi-tenant authorization and internal authorization/policy management

What is Apache NiFi?

Put simply NiFi was built to automate the flow of data between systems. While the term 'dataflow' is used in a variety of contexts, we use it here to mean the automated and managed flow of information between systems. This problem space has been around ever since enterprises had more than one system, where some of the systems created data and some of the systems consumed data. ... https://www.youtube.com/watch?v=fuEosO24fgI