CELEBRATING 25 YEARS OF DATA INTELLIGENCE SOLUTIONS It is our pleasure to celebrate our 25th anniversary this year!
Qlik Trainings 2023 Our 2023 training dates are here! Become a Qlik power user in our online or classroom courses.
CELEBRATING 25 YEARS OF DATA INTELLIGENCE SOLUTIONS It is our pleasure to celebrate our 25th anniversary this year!
Qlik Trainings 2023 Our 2023 training dates are here! Become a Qlik power user in our online or classroom courses.
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 Empower your Business Intelligence solutions with Microsoft’s SSIS, one of the leader tools of data integration field. 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 workbooks Relational databases such as SQL Server, Oracle, Sybase, MySQL, PostgreSQL On-premises or cloud application systems such as SAP, Hyperion, Salesforce and Mailchimp Protocols 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: 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