Success Story TopPharm TopPharm offers industry partners a secure KPIaaS platform for accessing sales data, based on Qlik & iVIEW and hosted in the Swiss BI Cloud.
Success Story FRED Financial Data AG FRED Financial Data AG ensures data quality for asset managers and optimizes processes through migration to Qlik Sense.
Success Story TopPharm TopPharm offers industry partners a secure KPIaaS platform for accessing sales data, based on Qlik & iVIEW and hosted in the Swiss BI Cloud.
Success Story FRED Financial Data AG FRED Financial Data AG ensures data quality for asset managers and optimizes processes through migration to Qlik Sense.
SQL SERVER INTEGRATION SERVICES (SSIS) Empower your Business Intelligence solutions with Microsoft’s SSIS, one of the leader tools of data integration field. Data extraction Data transformation Automation Azure Cloud Integration SQL Server Integration Services (SSIS) is a Microsoft tool for developing ETL processes for data integration. It is the successor to Data Transformation Services. With its ability to perform broad range of data integration tasks, SSIS offers an efficient and flexible way to implement Extract Transform and Load (ETL) solutions for the most common Data Warehousing scenarios.Microsoft offers SSIS Project Designer support as an extension in Visual Studio in which SSIS projects and packages are created and deployed. EXTRACT DATA FROM A WIDE RANGE OF DATA SOURCES Today data is stored in many different locations in many different formats. For a fast and efficient data integration solution, business users need a tool that can extract data from all these different sources and load it into a desired repository (Data Warehouse, Data Mart, Hub etc.).SSIS can connect to many different data source systems. Below some known examples of these data sources are listed:Files such as text, XML, Excel workbooksRelational databases such as SQL Server, Oracle, Sybase, MySQL, PostgreSQLOn-premises or cloud application systems such as SAP, Hyperion, Salesforce and MailchimpProtocols and queue systems such as HTTP/HTTPs (Web Service Task), MSMQ (Message Queue Task) TRANSFORM AND CUSTOMIZE THE DATA Data preparation is one of the most important steps of BI solutions as data isn’t always collected and stored in its best version or in the way that applies to business needs.Transformation of data is required to enable business users to be able to retrieve meaningful information from the data according to their needs. SSIS enables you apply a wide range of data transformations such as data aggregation, data type conversion, sorting, creation of derived columns, joining tables, lookups, pivoting/unpivoting columns and many more. Example SSIS Data Flow AUTOMATION Business users need up-to-date data; SSIS can handle this by scheduled ETL jobs in SQL Server and keep the SQL Server databases up to date without any user intervention. It only takes to set the scheduled jobs through Integration Services Catalogs which connect to SSIS packages and execute them in the days and/or times set. Jobs can be scheduled daily, weekly and monthly as well as they can occur multiple times in a day. It can also be set to send automatic notification in case of success or failure. SSIS AND AZURE CLOUD-INTEGRATION There may be plans to move the data to Azure Cloud in the future. Now it is possible deploy, run and manage SSIS projects and packages on Azure SQL Database or SQL Managed instance with known tools such as SQL Server Management Studio (SSMS). Alternatively, it is possible to proceed with a Hybrid ETL solution as in below example provided by Microsoft: SSIS in Azure Data Factory Microsoft Azure Data Factory is a cloud service that helps you create, schedule, and manage data pipelines to move and transform data.With Azure Data Factory, you can bring together data from different sources and use various data processing services to transform it.You can deploy and run SSIS packages in Azure Data Factory, which allows you to make use of your existing SSIS investments while taking advantage of the scalability and flexibility of Azure. This integration makes it easy to move data between on-premises and cloud systems and utilize the full range of data processing services available in Azure.Integrating Microsoft SQL Server Integration Services (SSIS) into Microsoft Azure Data Factory provides a flexible and powerful platform for data integration and transformation. It lets you leverage your existing SSIS investments while benefiting from the scalability and flexibility of Azure.Webinar: Data Warehouse with MS Azure Data Factory DATA ANALYSIS WITH QLIK AND POWER BI After having the data from different sources integrated, cleaned and prepared, structured in a data warehouse according to business needs in SSIS, it can be connected to Qlik or Power BI. A well-prepared data and in a well-structured data warehouse can easily lead to high-performance BI solutions with these tools which provide insights from right data to right users at the right time. Contact request for SQL SERVER INTEGRATION SERVICES (SSIS) Would you like more information on the topic of SSIS? Our specialists are at your disposal! You must have JavaScript enabled to use this form. Titel - Select -MrMs First name Last name Company Your Email Phone Message ✔ Privacy policy I hereby agree to the privacy policy. * Mandatory field to answer your request