Create a SQL Server controller service globally or specific to a data flow to simplify connectivity with the database and to perform ETL operations. SQL Server and DBCPConnectionPool controller services are available out-of-the-box to connect to Microsoft SQL Server or Microsoft Azure SQL databases.
The connected workflow will execute automatically in the background using a scheduling strategy (timer driven, CRON driven, event driven, or run once), or on-demand via an API or the Start and Stop buttons in the Operate panel.
You can read or write the changes made in the Data Integration Platform to the SQL Server automatically with full CRUD queries.
The Data Integration Platform stores the credentials in encrypted format in one place so they stay confidential and secure.