Localhost Postgres connection not working in BICS

Question

Summary

Content

I'm getting a query failed error when trying to run an analysis in BICS that is using a subject area derived from a Postgres connection.

So basically, I imported a local postgres database into BI Admin Tool (12c version) using the data direct driver. I then modeled the tables and create a subject area. The RPD passed the consistency checker just fine, and I was able to update row count / view data in the physical layer.

Next, I uploaded the RPD into BICS.. and the subject area shows up fine. But when I go to build even the simplest analysis.. i get a query failed.

Am I missing some step here.

FTisiot · Answer

hi

If you got the answer to your question you can maybe close the thread? It will help others with same/similar questions, right now it's still This question is Not Answered.

FTisiot · Answer

Hi,

Uploading the RPD doesn't upload your local database to the cloud. by default BICS expects to source data from the DBCS it's attached to.

You can either use Oracle BICS Data Sync  to upload your data into DB Cloud Service and repoint your RPD to work from there or use Oracle BICS Remote Data Connector to connect your BICS instance to your local Postgres database.

You can check http://www.ateam-oracle.com/configuring-the-remote-data-connector-rdc-for-bi-cloud-service-bics/ how to connect  BICS  to your local Postgres DB