SSIS Information

Question

I am new in SQL Server, using developer edition. Actually I want to use SSIS for ETL Process. I want to know that SSIS works with only Integration Services or it also works with database engine, analytics service, reporting services of sql server. Mean my target database can be database engine, analytics service, reporting services or not?

Another is that can we use SSIS for other database such as Oracle, Teardata and limitations of Developer edition in sense of data storage quantity ?

Answer 1

Another is that can we use SSIS for other database such as Oracle, Teardata

SSIS can access any data sources, where you have a working OleDB, ODBC or .NET data provider for; see Integration Services (SSIS) Connections

limitations of Developer edition in sense of data storage quantity ?

Developer Edition has the same unlimited feature set as the Enterprise Edition, see Integration Services features supported by the editions of SQL Server

Answer 2

Hi @Waris Shah ,

1.SQL Server Integration Services * is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.*

2.The SSISDB catalog * is the central point for working with Integration Services (SSIS) projects that we've deployed to the Integration Services server.* We access the SSISDB catalog in SQL Server Management Studio by connecting to the SQL Server Database Engine and then expanding the Integration Services Catalogs node in Object Explorer.

3.SQL Server Data Tools (SSDT) * is a modern development tool for building SQL Server relational databases, databases in Azure SQL, * Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, we can design and deploy any SQL Server content type with the same ease as we would develop an application in Visual Studio.

4.Analysis Services * is an analytical data engine (Vertipaq) used in decision support and business analytics.*
SQL Server Reporting Services (SSRS) * provides a set of on-premises tools and services that create, deploy, and manage mobile and paginated reports.*

Best regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.