Posts Tagged ‘DataSync’

A new ERP system presented a financial reporting challenge for one of the top specialty contractors in the U.S. – the means to assemble financial data from multiple systems (Penta ERP, ADP, and other custom-built applications) and easily distribute that information to various business unit leaders. The current solution required manual intervention and was very […]

Following my previous blog post on how to add a new Dimension to a Data Sync task, this post looks at how to add a Fact and perform a lookup on dimensions while loading the target fact table in a data warehouse using Data Sync. To refer to the blog post on adding a Dimension […]

In this and the following post, I will cover the steps entailed in adding dimension and fact tasks in Oracle Data Sync. The latest releases of Data Sync included a few important features such as performing look-ups during an ETL job. So I intend to cover these best practices when adding new dimension and fact […]

Earlier this week, Oracle upgraded its BI Cloud Service platform as well as DataSync (now version 2.2) for cloud integrations. With those 2 upgrades come great benefits if you have any of the following and looking to do consolidated business analytics from multiple source systems and allow for cross-functional insights: Salesforce: There is no need […]

There are several ways of integrating data with Oracle BI Cloud Service (BICS). While some of these are tailored for end users and therefore offer agility and ease of use, others are targeted to scale and support automation. In my Collaborate 16 session tomorrow, I will be going through the different techniques and demos of […]

If you have used ETL tools like Informatica or ODI, you probably know that it is possible to perform delete operations on a target database, like a data warehouse. But if you are using Oracle BI Cloud Service with the Schema Database as a data warehouse for BICS, you won’t be able to connect to […]