DataSync Articles - Perficient Blogs
Blog

Posts Tagged ‘DataSync’

  • Topics
  • Industries
  • Partners

Explore

Topics

Industries

Partners

Automating Financial Reporting with Oracle Analytics Cloud

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 […]

Read more

Oracle BI Data Sync: How to Add a New Fact

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 […]

Read more

Oracle BI Data Sync: How to Add a New 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 […]

Read more

Oracle BICS for Salesforce, RightNow, Amazon, IBM & Big Data

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 […]

Read more

Collaborate: Perficient Explains REST API Methods for Oracle BICS

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 […]

Read more

BI Cloud Service: How to Automate Delete Jobs with DataSync

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 […]

Read more

Subscribe to the Weekly Blog Digest:

Sign Up