What does "SSIS" stand for?
Welcome to another exciting game of Data Truth or Dare
. This round’s question is about the term "SSIS." Because keeping track of all those tech acronyms can be tough.
Is it an acronym for "Structural Server Integration Services?" OR "SQL Server Integration Services?"
SSIS is a broad range of data-migration tasks for Microsoft SQL Servers, otherwise known as SQL Service Integration Services (SSIS). SSIS is used by developers to perform data extraction, transformation, and loading (also known as the ETL). It is this tool that is utilized when moving data from your ERP and other systems into a data warehouse. This is also where consultants define the frequency of data updates, and can perform advanced calculations and manipulations that reflect your business logic on your data.
Once it's in the data warehouse is where the magic really happens ...
Keep your BI vocabulary sharp with our ongoing Data Truth or Dare series here on the blog.
Content Marketing Manager
A professional writer, communicator, and marketer by trade, I'm fascinated by the way data - and in particular big data - is changing the way companies do business. As Content Marketing Manager for TARGIT I tackle this topic and many others in my mission to expand TARGIT's footprint and show the world exactly what it means when you have TARGIT in your tool box. I..