We just raised a $30M Series A: Read our story

SSIS Questions

Netanya Carmi
Content Manager
IT Central Station
RajneeshShukla
Solution Architect at a tech vendor with 10,001+ employees
Sep 09 2021
Hi, I am working as a solution architect for a tech vendor with 10,000+ employees.  I need to perform comparative analysis for ETL tools available to populate data from OLTP to OLAP. The main criteria I am considering are: Price Functionality (transformation, error logging and handling,… (more)

Hi,

I am working as a solution architect for a tech vendor with 10,000+ employees. 

I need to perform comparative analysis for ETL tools available to populate data from OLTP to OLAP.

The main criteria I am considering are:

  • Price
  • Functionality (transformation, error logging and handling, loading patterns to be supported)
  • Development and maintenance efforts
  • Popularity in the market.

I want to evaluate both Oracle and Open Source options. I am also open to both tools (ODI, Golden Gate, etc) and technology- e.g. Oracle Materialized view.

Thanks! I appreciate your help. 

(less)
AThiréThere are two products I know about * TimeXtender : Microsoft based,… more »
Stefan SchäferWe usually use Talend. Look here:… more »
Karoly KrokovayWe have experiences only in Pentaho Data Integrator (open source competitor of… more »
Miriam Tover
Content Specialist
IT Central Station
Sep 01 2021

If you were talking to someone whose organization is considering SSIS, what would you say?

How would you rate it and why? Any other tips or advice?

Julia Frohwein
Content and Social Media Manager
IT Central Station
Sep 01 2021

Hi,

We all know it's really hard to get good pricing and cost information.

Please share what you can so you can help your peers.

GaryMAre you aware that SSIS is free if you own SqlServer? And that’s just… more »
Julia Frohwein
Content and Social Media Manager
IT Central Station
Sep 01 2021

Please share with the community what you think needs improvement with SSIS.

What are its weaknesses? What would you like to see changed in a future version?

GaryMSSIS largest weaknesses right now are 1) Visual Studio/SSDT is only 32 bit. It… more »
Miriam Tover
Content Specialist
IT Central Station
Sep 01 2021

How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

AltanAtabarutI'm using the solution primarily for e-memory and e-database calculation, mostly… more »
Bob AmyWe use this solution to ingest data to a data lake that is built on SQL Server.
Muhammad Arif JavedWe have used SSIS in many ways. Primarily, it has been used for building ETLs… more »
Miriam Tover
Content Specialist
IT Central Station
Sep 01 2021

Hi Everyone,

What do you like most about SSIS?

Thanks for sharing your thoughts with the community!

Data Integration Tools Questions
Ariel Lindenfeld
Sr. Director of Community
IT Central Station
Jul 08 2021

Hi peers,

When evaluating Data Integration tools, what aspects do you think are the most important to look for? Let the community members know what you think. 

Thank you for sharing your knowledge!

Phil WilkinsI would be looking for things like: - types of connections supported - data… more »
Nida Fatima- Ease of use - The solution should offer the same level of usability to both IT… more »
Arthur KancelaroviczHello, My experiences says : 1. Project budget; 2. Needed connection(s)… more »