HubSpot Operations Hub (based on technology from the former PieSync that was acquired by HubSpot November 2019) is a two-way contacts integration platform. The vendor emphasizes quick and easy setup automated customer and client data matching and updating between apps.
$45
per month
Oracle Data Integrator (ODI)
Score 8.3 out of 10
N/A
Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.
In cases of brands that have been in the market for a long time but do not see any impact from new clients or consumers, HubSpot is ideal since it allows to keep the brand fresh in the mind of the audience. HubSpot additionally provides insight into what we're doing and allowed us to align the sales team with company goals. It also ensures that you receive updates from your computer. We can handle all programming requests that come into our team. One thing that HubSpot can improve on is not having a good centralized dashboard that allows for a full view of ALL data coming in. You can go to each piece, but not having them all attached to the board adds a bit of a challenge. It's not very complex to handle, but it would be easier to use if it had that feature.
Oracle Data Integrator is well suited in all the situations where you need to integrate data from and to different systems/technologies/environments or to schedule some tasks. I've used it on Oracle Database (Data Warehouses or Data Marts), with great loading and transforming performances to accomplish any kind of relational task. This is true for all Oracle applications (like Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, and so on). I've also used it to manage files on different operating systems, to execute procedures in various languages and to read and write data from and to non-Oracle technologies, and I can confirm that its performances have always been very good. It can become less appropriate depending on the expenses that can be afforded by the customer since its license costs are quite high.
Easy to figure out. Once you login, it's incredibly easy to figure out what to do, thanks to their simple UIX.
Easy integrations with many partners. PieSync offers easy integrations with many partners. Integrating is as easy as clicking, filling in your login information and clicking again!
Allowing multiple integrations. I'm glad PieSync allows multiple integrations so you aren't limited with how you integrate your different systems with contact information. Very helpful!
Oracle Data Integrator nearly addresses every data issue that one can expect. Oracle Data Integrator is tightly integrated to the Oracle Suite of products. This is one of the major strengths of Oracle Data Integrator. Oracle Data Integrator is part of the Oracle Business Intelligence Applications Suite - which is highly used by various industries. This tool replaced Informatica ETL in Oracle Business Intelligence Applications Suite.
Oracle Data Integrator comes with many pre-written data packages. If one has to load data from Excel to Oracle Database, there is a package that is ready available for them - cutting down lot of effort on writing the code. Similarly, there are packages for Oracle to SQL, SQL to Oracle and all other possible combinations. Developers love this feature.
Oracle Data Integrator relies highly on the database for processing. This is actually an ELT tool rather than an ETL tool. It first loads all the data into target instance and then transforms it at the expense of database resources. This light footprint makes this tool very special.
The other major advantage of Oracle Data Integrator, like any other Oracle products, is a readily available developer pool. As all Oracle products are free to download for demo environments, many organizations prefer to play around with a product before purchasing it. Also, Oracle support and community is a big advantage compared to other vendors.
The biggest issue we have had with PieSync is the lack of detail within syncing. Sometimes when there is an issue with a Sync it is hard to determine what went wrong. Even though most of the time it's user error, it's hard to diagnose issues with the current PieSync set-up.
The pricing of PieSync is a little odd and I think should be based on something other than number of contacts you're syncing.
ODI does not have an intuitive user interface. It is powerful, but difficult to figure out at first. There is a significant learning curve between usability, proficiency, and mastery of the tool.
ODI contains some frustrating bugs. It is Java based and has some caching issues, often requiring you to restart the program before you see your code changes stick.
ODI does not have a strong versioning process. It is not intuitive to keep an up to date repository of versioned code packages. This can create versioning issues between environments if you do not have a strong external code versioning process.
It is maturing and over time will have a good pool of resources. Each new version has addressed the issues of the previous ones. Its getting better and bigger.
Every time that I've had a question, PieSync has been very responsive. It is a reliable company with a great team that is devoted to helping their customers. I've been their customer for 2 years and I've never looked back. Support is an important reason why PieSync is my go-to app for this job.
PieSync is much less confusing, and from what I remember, cheaper. But if you need a more robust solution to get more data from system to system, you will need to find something other than PieSync. Zapier can be confusing and complicated to setup. And as you get more and more into the weeds with Zapier, you start realizing that you need to upgrade from plan to plan as you add these more complicated steps.
I have used Trifacta Google Data Prep quite a bit. We use Google Cloud Platform across our organization. The tools are very comparable in what they offer. I would say Data Prep has a slight edge in usability and a cleaner UI, but both of the tools have comparable toolsets.
