Oracle Data Integrator (ODI) vs. Salesforce Data 360

I tried various ETL tools and here is [where and] why I recommend Oracle Data Integrator. 1. When you want to process structured data from different databases - Teradata, Exadata, DB2, SQL, Oracle etc. 2. Oracle Data Integrator supports all platforms, hardware, and OS. This is a major advantage compared to other leading tools. 3. The ELT architecture giving a cutting edge performance over leading ETL tools. There is no need to align Oracle Data Integrator between source and target. ODI uses the source and target servers to perform complex transformations. 4. Speeds up the development and maintenance by reducing the code that developers need to write

Incentivized

Great tool for client management, sales tracking, cases studies. Using is as the source of truth for all client communication. Allowing more integration options for cc and ACH payments. Right now the options are limited and only integrate with strict processing capabilities that are not always in the businesses best interest.

Incentivized

• Converts data from various sources into one target format using various business logic rules and integrates with various DBMS types.
• Transformed data from DB2, SQL Server and other Oracle databases into flat files and then used ETL jobs to load into Oracle DB target
• Data Integrator and Goldengate were used together to accomplish the data movement needed for business and data consolidation in live environment. Data Integrator helped with development and in reducing lead time to convert data into target.

Incentivized

• Allows use to bring external data into Salesforce as zero-copy
• Is able to present data using standard Salesforce reports familiar to our users
• Allows us to establish multiple relationships between our CRM data and the external data to contextualize the imported data.

Incentivized

• Oracle support is not the best when needing help with the system
• The documentation is also very poor and takes very long to generate
• Some parts of it are not intuitive to use and get hard to troubleshoot
• Like other Oracle products, you must have very, very thorough knowledge about their systems to understand
• Like all Oracle products, cost is high

Incentivized

• pricing or costing visibilty, we can't estimate what would be consumption this month and suddenly we get surprised
• CI/CD can be improved, that looks a difficult and hard
• Also sandbox comes with many limitation so very hard to replicate production like environment to test

Incentivized

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.

I gave rating 8 because it offers powerful data unification, strong insight , improved customer interaction and reliable performance. This rating also includes overall data visibility and usability across teams. The reason of not giving 10 is its complexity sometimes and costing. This can be less efficient and more complicated for sometimes.

Talend Data Integrator has been evaluated during the setup of the architecture for a customer, in comparison to ODI, since it's an open source ETL. But, differently from the meaning of "open source", it has licence costs too that aren't that different from ODI ones. Moreover, the other components of the business intelligence architecture of the customer were Oracle, so we thought that ODI would suit at best with them, more than a different vendor software.

Incentivized

Salesforce has different version which can de adequate to smaller companies like ours. It also has a more complete suite than the others, is easier to use and way faster to start using it. Their support and sales team are very friendly and attentive. They're always ready to answer our questions, and what I like the most is that humans always respond our question, not AI like most of the other tools assistance.

Incentivized

• Oracle Data Integrator helps provide a business with the data it needs to defend the decisions it makes.
• Oracle Data Integrator allows you to analyze data from what can be separate, different, and often outdated data sources. It allows you to make direct comparisons when analyzing data from different pieces of equipment.
• Data from Oracle Data Integrator was used to analyze manufacturing quality and drive down spoilage, saving the company money.

Incentivized

• Salesforce Data Cloud has a positive impact on me as a realtor because it is easy to generate reports on customer data and see what is needed to be bumped to the next level. We have to earn a certain commission by the end of the year and it makes it easy to see how close you are
• It has a positive impact on keeping track of customers because it is nice to have it all in one place which is a nice time saver
• I like that you can even see customer info from other agents making it nice to compare and try and pass others
• Makes the customers journey smooth sailing because everything is in one place

Incentivized