Transcription
Data IntegrationA PEEK INTO WHAT REAL USERS THINK2015IT Central Station helps tech professionals by providing.A comprehensive list ofenterprise level DataIntegration vendors.A sample of real userreviews from techprofessionals.Specific information to helpyou choose the best vendorfor your needs.DisclaimerIT Central Station Ltd. does not endorse or recommend any products or services. The views and opinions of reviewersquoted in this document, IT Central Station websites, and IT Central Station materials (i.e. Content) do not reflect theopinions of IT Central Station. We make no guarantees about the accuracy, currency, suitability, or quality of the content, andwe assume no responsibility for unintended, objectionable, inaccurate, misleading, or unlawful content made available byContent authors or other third parties. 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
ABOUT IT CENTRAL STATIONUser reviews, candid discussions, and more for enterprise technologyprofessionals.The Internet has completely changed the way we makebuying decisions. We now use ratings and review sitesto see what other real users think before we buyelectronics, book a hotel, visit a doctor or choose arestaurant. But in the world of enterprise technology,most of the information online and in your inbox comesfrom vendors but what you really want is objectiveinformation from other users.We created IT Central Station to providetechnology professionals like you with acommunity platform to share information aboutenterprise software, applications, hardware andservices.Use IT Central Station to: Read and post reviews of vendorsand products Request or share information aboutfunctionality, quality, and pricing Contact real users with relevantproduct experience Get immediate answers to questions Validate vendor claims Exchange tips for getting the bestdeals with vendorsWe commit to offering user-contributed information thatis valuable, objective and relevant. We protect yourprivacy by providing an environment where you canpost anonymously and freely express your views. As aresult, the community becomes a valuable resource,ensuring you get access to the right information andconnect to the right people, whenever you need it.244 5th Avenue, Suite R-230New York, NY ion.com 1 (646) 328-1944 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
ABOUT THIS REPORTThis report is comprised of a comprehensive list of enterprise level server virtualization softwarevendors. We have also included several real user reviews posted on ITCentralStation.com. Thereviewers of these products have been validated as real users based on their LinkedIn profiles to ensurethat they provide reliable opinions and not those of product vendors.IMPORTANT NOTICEDid you find this whitepaper helpful? At IT Central Station, our philosophy is “Give to Get”. Our activecommunity and unbiased reviews are made possible by your participation and as such, we ask that youshare your expertise with us as well. Please email reviews@itcentralstation.com and one of ourcommunity managers will be in touch with you shortly. You can choose to review anonymously or notand your company name will not be included in the review.If you found this report and/or the reviews on IT Central Station useful, we would greatly appreciate yourparticipation in giving back to our community. 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
VENDOR (BY racleGoldenGateMicrosoftSSISOracleOracle Data IntegratorIBMInfoSphere Information ServerActianPervasive Data IntegratorSAPBusinessObjects Data ServicesInformation BuildersData HubTalendOpen StudioTalendTalend Integration SuiteSAPBusinessObjects Data FederatorSAPBusinessObjects Data IntegratorInformaticaCloud Data IntegrationAb InitioCo Operating SystemSASData Management PlatformActianDataCloudInformation BuildersDataMigratorActianDataRushDenodoDenodo 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationRating: 8.4(6 reviews)Rating: 7.34(7 reviews)Rating: 9.0(11 reviews)Rating: 9.0(27 reviews)Rating: 9.0(10 reviews)Rating: 10.0(3 reviews)Rating: 2.0(16 reviews)Rating: 6.0(2 reviews)Rating: 10.0(1 reviews)Rating: 8.0(1 reviews)Rating: 8.0(1 reviews)Reproduction Prohibited
SyncsortDMExpressInformation BuildersEIM SuiteSASEnterprise Data Integration ServerSASFederation ServerIBMInfoSphere Data Event PublisherIBMInfoSphere Replication ServerActianIntegration HubActianMetadata ManagerSAPNetWeaver Process IntegrationInformation BuildersParallel Service ManagerInformaticaPowerExchangePrimary DataPrimary DataSASSAS for Data MigrationSASSAS/AccessSAPSybase Replication ServerUNIFi SoftwareUNIFi SoftwareInformation BuildersUniversal Adapter FrameworkOracleWarehouse Builder 2015 IT Central StationTo read more reviews about Data Integration, please a-integration(3 reviews)(1 reviews)(3 reviews)Reproduction Prohibited
Top Data Integration VendorsOver 73,636 professionals have used IT Central Station research on enterprise tech solutions. Here arethe top Data Integration vendors based on product reviews, ratings, and comparisons. All reviews andratings are from real users, validated by our triple authentication process.1. PowerCenter74372. Oracle Data Integrator37383. DataFlux18434. Pervasive 18705 Re283 FAviollow verage Rparis ewsatingersons: 7.4Com3 Re239 FAviollow verage Rparis ewsatingersons: 9.0Com5 Re213 FAviollow verage Rparis ewsatingersons: 8.4Com4 Re157 FAviollow verage Rparis ewsatingersons: 2.0ComChart KeyViews: Number of total page viewsComparisons: Number of times compared to another productReviews: Total number of reviews on IT Central StationFollowers: Number of followers on IT Central StationAverage Rating: Average rating based on reviewsThe total ranking of a product (i.e. bar length) is based on a weighted aggregate ranking of that product's Views (weighting factor Rating (30%).Prohibited 2015 IT Central 17.5%),Station Comparisons (17.5%), Reviews (17.5%), Followers (17.5%), and AverageReproductionTo read more reviews about Data Integration, please a-integration
TOP 5TOP 5Based on ViewsBased on Views of Center5893GoldenGate7275SSIS5736SSIS4104Warehouse Builder4162Warehouse Builder3738Oracle Data Integrator3278Oracle Data IntegratorTOP 5TOP 5Based on FollowersBased on Rating417GoldenGate10.0Data Hub397SSIS10.0InfoSphere Information Server283PowerCenter9.0GoldenGate239Oracle Data Integrator9.0SSIS226Sybase Replication Server9.0Oracle Data Integrator 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
DataFluxVendor: SASTopComparisons:*SSIS vs. DataFluxCompared 7% of the time.Informatica Data Quality vs. DataFluxCompared 7% of the time.PowerCenter vs. DataFluxCompared 4% of the time.* Data is based on the aggregate profiles of IT Central Station Users researching this solution. 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
DATAFLUX REVIEW BY A REAL USERJoseph DiVenere Verified by IT Central StationArchitect at a wireless company with 5000 employeesImprovements to My Organization:I’ve used this product in multiple ways. Initially, I integrated it with QAS addresssoftware to validate and standardize customer website registration data in realtime, loading the cleansed customer data into Siebel CRM. I’ve used the dataprofiling reports to identify errors in ETL jobs and enterprise data warehouses. I’vebuilt business rule metrics that score ETL jobs in terms of data completeness anddata accuracy between the business application data store and the enterprise datawarehouse. All efforts have proved invaluable to the business user.Use of Solution:SAS Data Management Studio V 2.4Deployment Issues:While the deployment is more complex now that it was 7 years ago, if you follow thedetailed instructions from SAS regarding the software depot deployment, it is notdifficult, and can be completed in 1-2 hours easily.WHAT REAL USERSARE SAYING."Very powerful options interms of Data Profiling,Data De-duplication, andprogramming complexdata cleansing rules.""Data Governance needsspecific tools, don't try tosurvive with user writtencodes"" For the amount offeatures that we use, thelicensing is expensive.""Access data from acrossthe enterprise with thishigh end solution"Stability Issues:The server side component runs rock solid on Linux. The Windows clientcomponent is less stable, and may require a restart a few times a day, especially ifinstalled on a PC with limited RAM and you are dealing with very large data stores.Since I’m one major release behind in this software, it’s possible these clientstability issues have been corrected in the most recent release.Scalability Issues:Very large data stores require a powerful server to run the data profiling reports forall of the rows in the database. My estimate for “very large” is a database 200million records.Customer Service:When DataFlux was a standalone company, the customer service deserved an A rating. Now that it is a wholly owned subsidiary of SAS, and just one piece of agiant software conglomerate, I would give them a C . 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
Technical Support:Technical support is strong at resolving install and configuration issues of the clientside tool. You will need to speak with a SAS DataFlux consultant to debug complextechnical issues related to the data quality jobs you code, or server side problems.Implementation Team:I’m an independent DataFlux consultant, so I am “the vendor”. I’ve partnered withSAS consultants on implementations, as well as performed solo installations. SASDataFlux consultants are top notch in their expertise of the tool and data. But theyare not required to install successfully, just add a level of confidence.ROI:The ROI can be very high in terms of improving the reliability and accuracy of dataused in forecasting and marketing models (ex: customer data, sales data). You canalso reduce storage costs; slow the need for hardware upgrades by using DataFluxto eliminate duplicate data. Even better, use DataFlux to audit your ETL and datawarehouse efforts, insuring accurate reporting. CEOs and CIOs will drop 10M fora new ERP system installed by a big-4 consulting firm, and then balk at 5% of thiscost to insure that the data stored in this complex and costly ERP system is notcorrupt or full of duplicate data.Alternate Solutions:Yes, including Business Objects, IBM’s Infosphere, and Trillium.Other Advice:Take the time to send a minimum of 3 of your most technical data architects toonsite training at SAS in Cary, North Carolina. Their facilities and teachers areexcellent, and this training is of great benefit for your organization over the longterm. 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
DATAFLUX REVIEW BY A REAL USERreviewer154305 Verified by IT Central StationPrincipal & Manager at a consultancy with 1-500employeesValuable Features:National Quality Knoledge BaseMatching featuresQPI (Quality Performance Indicator) analysis approachImprovements to My Organization:High performances in matching toolRoom for Improvement:ETL functionsUse of Solution:Since 2012Deployment Issues:Proprietary programming languageStability Issues:Not at allScalability Issues:No, high integration level with SASCustomer Service:HighTechnical Support:High 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
Previous Solutions:Informatica PowercenterLack of data quality governance featuresInitial Setup:Complex, as usual with SASImplementation Team:The vendor team was from SAS, high level of expertiseROI:HighConsider that, for Data Governance, the meaning of ROI may be Risk Of InactionsAlternate Solutions:IBM QualityStageOther Advice:Data Governance needs specific tools, don't try to survive with user written codes 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
PowerCenterVendor: InformaticaOverview:Enterprise data integration platform to help organizations access, transform, and integrate data from avariety of systems.TopComparisons:*Warehouse Builder vs. PowerCenterCompared 55% of the time.SSIS vs. PowerCenterCompared 9% of the time.PowerExchange vs. PowerCenterCompared 5% of the time.Top Industries:* Media CompanyCompany Size:*13%Financial Services Firm12%Healthcare Company9%Comms Service Provider8%1-500 Employees14%500-5000 Employees28%5000 Employees58%* Data is based on the aggregate profiles of IT Central Station Users researching this solution. 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
POWERCENTER REVIEW BY A REAL USERSrSpecialist59112 Verified by IT Central StationData Quality and Conversion at a tech services companywith 5000 employeesValuable Features:The possibility to create a data profiling mapping automatically from any importedsource.WHAT REAL USERSARE SAYING."As ETL tools in general, itdoes not include a gooddata reporting feature.""High performance andscalable data integration"The client installation includes a macro that can be imported into Excel. This willcontains standard documents for technical design and documentation in general.The technical design developed in Excel can be directly imported into Powercenterusing Powercenter Repository Manager and the corresponding mapping isautomatically created. This can save a lot of development time for simple or notvery complex mappings. This feature is called Mapping Analyst for Excel.The default error handling, automatically created, is quite good for thosearchitectures that don't have a proper one or a budget for a custom one.Room for Improvement:As all ETL tools in general, it does not include a good data reporting feature.Another one is the component called "Union" which includes some bugs:Adding new groups, the field-names are lostAdding new fields, the field type should be reset for all fields in the "Union" or themapping validation will fail.There is no possibility of handle non matching records in a "joiner" as in DataStage.Use of Solution:4-5 years, different versions.Deployment Issues:NoStability Issues:No 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
Scalability Issues:NoPrevious Solutions:I used other tools like IBM DataStage. The final decision is made by my clients butwhat I see is that clients using DB2 prefer to use DataStage over Informatica asboth (DB2 and DataStage) are IBM products.Initial Setup:Very straightforward.Implementation Team:In-house 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
POWERCENTER REVIEW BY A REAL USERitadmin Verified by IT Central StationHead of Databases at a retailer with 500-5000 employeesValuable Features: As it supports large data volumes, so it meets the demands of our company forsecurity and performance. It helps us in making better and timelier business decisions by providing us theright information at the right time. Delivers data throughout our enterprise by accessing and integrating data in allformats. Provides security, scalability, performance to our system and establishes afoundation for our enterprise-wide data integration initiatives. Enables our teams of developers, analysts, and administrators to work fasterand better together and also reduces our IT costs by encouraging collaboration andminimizing the development complexities.Room for Improvement: It is very expensive. High end. We provided training of SQL to our staff before using this product. Because agood understanding of SQL is mandatory for using Powercenter. GUI: Lack of clarity and consistency created problems for our staff. So it requiressome improvements. We used the services of highly skilled persons for installation of powercenter.Novice staff can’t install this product properly.Other Advice:Our organization is using it because it is one of the leading data integration toolsavailable in the market and supports large data volumes and meets our demandsfor security and performance. PowerCenter is serving as the data integrationfoundation for our enterprise integration initiatives including data warehousing, datagovernance, data migration, SOA), and MDM. Powercenter in my opinion has thebest data transfer technologies including its standard, advanced, big data, realtime, data virtualization and cloud editions. 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
GoldenGateVendor: OracleTopComparisons:*SharePlex vs. GoldenGateCompared 26% of the time.SSIS vs. GoldenGateCompared 9% of the time.Oracle Data Integrator vs. GoldenGateCompared 8% of the time.* Data is based on the aggregate profiles of IT Central Station Users researching this solution. 2015 IT Central StationTo read more reviews about Data Integration, please a-integrationReproduction Prohibited
GOLDENGATE REVIEW BY A REAL USERdba407 Verified by IT Central StationDatabase Expert at a healthcare company with 500-5000employeesValuable Features:This product is meant to replace Oracle's Data Guard replication. The setup issimple and it can handle bi directional replication very easily. Training cost isminimal and most DBAs self learn this product. replication between various types ofdatabases is supported and software foot print is very small . Change trails are notvery big and easy to manage and store.WHAT REAL USERSARE SAYING."Great Replication toolwhich gives easy of setupand a small softwarefootprint ""Data replication isseamless but time to valuecan be long"Room for Improvement:DDL (data definition language) replication is still to mature and can be an issue.Supplemental logging causes extra redo log generation in the log storage.Licensing cost is higher as compared to other replication products. Configuration ofGolden Gate in HA (High Availability) mode needs setup of extra VIPs which canbe challenging in a RAC environment.Other Advice:Integration of Golden Gate with monitoring tools like OEM (Oracle EnterpriseManager) is still not available and most DBAs monitor this with custom scripts. Wechose this product mostly on it's bidirectional replication feature and easy setup.Some applications are using this as a messaging mechanism between multipledatabases. 2015 IT Central StationTo read more reviews about Data Integration, please a-integratio
Apr 16, 2015 · 2. Oracle Data Integrator 3738 Views 3278 Comparisons 3 Reviews 239 Followers Average Rating: 9.0 3. DataFlux 1843 Views 2994 Comparisons 5 Reviews 213 Followers Average Rating: 8.4 4. Pervasive Data Integrator 1801 Views 1870 Comparisons 4 Reviews 157 Followers Averag
