Toad Data Point Competitors and Alternatives

Read reviews of Toad Data Point competitors and alternatives
D5555ca7 bd65 453c 9b0c 3f135d79238b avatar?1436899911
Consultant
Technical Advisor at Gluent Inc
Oct 31 2016

What is most valuable?

The biggest feature for ODI is the fact that it uses the power of the source or target database to actually perform the ETL processing. So a typical data integration tool might have its own ETL engine, and that would be an additional server, additional costs, something else you have to maintain. ODI actually has the ability to create and generate code that runs... more»

What needs improvement?

One thing that is included, and it's going to improve, is the integration with a configuration management tool. Right now, they integrate with Subversion. And we know in the future, there's going to be more tools implemented there for configuration management and some new features there. So right now, it's kind of one of those features that, it's been released,... more»
Wherescape avatar twitter reasonably small
WhereScape
Picture 1288 1365323206
Real User
Data Architect at a non-profit with 1,001-5,000 employees
Dec 29 2017

What is most valuable?

Documentation has excellent potential as it provides the capability to generate data lineage and a complete set of rich documentation and output in multiple formats. The tool supports multiple target update methods. Support for multiple... more»

How has it helped my organization?

It did not pass usability, reliability, sustainability or performance tests so there was no potential benefit other than minor documentation advantages over the current automated documentation solution.

What needs improvement?

In my opinion, the tool requires a much different architectural approach to be effective. It has fundamental architectural flaws that prevent it from being a practical solution for even moderate volumes of data. The largest issue is that it... more»
Microsoft 400x400
Microsoft
Picture 1288 1365323206
Real User
Data Architect at a non-profit with 1,001-5,000 employees
Dec 29 2017

What do you think of SSIS?

Sql Server Integration Services (SSIS) 2016 Review Summary SSIS 2016 - the Good the Bad, and the Ugly SSIS is a unique ETL tool for a number of reasons. Most shops already own it but may treat it as a one-off free utility rather than as an enterprise ETL tool even though it can compete with the best of ETL tools. Some of the lack of respect is due to immature beginnings in its former "DTS" days. And some of it is because it comes bundled with Sql Server and does not require a separate ETL server.  It can't be good if its free right?  Especially when competitors easily charge 6 figures for the same or lesser functionality. Don't we get what we pay for?  My answer is, generally yes but this may be an exception worth noting. SSIS has become extremely flexible,...
2aa4c284 3c4a 444f 8fb6 defc7039139f avatar
Real User
Data Warehousing and Business Intelligence Lead at Bank of America
Oct 06 2016

What is most valuable?

* Able to access heterogeneous databases: It can work with any kind of database available in the market. In fact, it can be applied to NoSQL databases as well. * SQL override allows users to write simple to complex queries inside mapping for... more»

How has it helped my organization?

Our organization had to import data from AS400, implement a sales cost analysis and load data into Data Mart, which was further consumed by QlikView. This was done with data from five different countries in different time zones. From the... more»

What needs improvement?

There are three areas where they can make a significant improvement: * Live feeds, where if a database object changes then object definitions should automatically get refreshed as well. This would avoid re-import of objects. Auto refresh will... more»
71a29f2f 8832 4dfe b435 cedcd4452011 avatar
Consultant
Enterprise DWH Architect - Oracle ACE Director at Ekol Logistics Corp.
Mar 27 2017

What is most valuable?

Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service).

How has it helped my organization?

Replicated source system data seamlessly flew in our Operational Data Store (ODS). Different types of source systems (IBM DB2, Microsoft SQL Server) are supported for real time replication. With the upgrade, I now can able to replicate Big... more»

What needs improvement?

Oracle GoldenGate Studio could be more user-friendly. It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others).
D099cb99 58fe 4c16 bfcb f15ecd4b2f83 avatar
Real User
Solution Architect at Zaizi Ltd
May 23 2017

What is most valuable?

It is a powerful tool for data integration: You can simply drag & drop components and draw lines to connect them together for building your ETL job. There is a list of +900 components available OOTB.

How has it helped my organization?

If you are a data integrator or system integrator, your work will be much easier using Talend Open Studio. It is an Eclipse-based application; therefore, any developer which has used Eclipse before is able to build jobs and run them.

What needs improvement?

The open-source version does not include the parallel execution; neither the source code versioning or the project collaboration features.

Sign Up with Email