SQL Server Integration Services (SSIS) Solution | Broadcom Insights Partner | PRODUCTION

HCLTech

Paid

SQL Server Integration Services (SSIS) Solution

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server Business Intelligence platform that can be used to perform a broad range of data migration tasks. The Automic integration into SSIS leverages the command line API provided by Microsoft to perform batch execution of SSIS packages.

Features

Ideally ETL processes should wait until processes that update source data have completed. But the typical method to scheduling SSIS packages is to use SQL Server Scheduler at specific times when the data "should" be ready. This can result in delays in updating Business Intelligence data and/or incomplete data. This Packaged Solution connects the ETL processes to the business processes already being scheduled in Automic Automaton so that ETL processes start immediately upon completion of the source systems updates and not before. The SSIS solution for Automic Automation allows customers to define complete end-to-end processes with all the necessary dependencies included.

• Template Job object for SSIS jobs
• Supports packages stored on local file system, SQL Server File System, or SQL Server Package Store

Specifications

Supports Automic Automation 21, Supports AppWorx Workload Automation 9.x, Supports SQL Server 2008 R2 to 2022

Integration Info

More Integrations from this Partner

- Paid
Paid
ESP dSeries to Automic Workload Conversion Engine
This solution is an HCL-developed conversion accelerator designed to migrate jobs from ESP dSeries to Automic quickly and efficiently.

Built based on a real customer implementation, the tool is capable of automatically converting approximately 80% of jobs without manual intervention, significantly reducing migration time, effort, and risk. For environments using standard product features, conversion rates can reach up to 90%.

The solution continuously evolves to support complex and customized dSeries environments. It leverages exported job definitions as input and generates ready-to-deploy artifacts for the target Automic platform.As an HCL intellectual property asset, this accelerator can be reused across different customers and regions, enabling faster modernization of workload automation platforms.The conversion is performed by HCL, and the generated output is delivered to the customer for deployment, ensuring control, quality, and consistency. carlos.jupia@hcltech.com (HCL ES)