OACS and Redshift

[Jit Dutta]

Hi,

Any one knows if we can have OACS OBIEE reporting with EDW hosted in Amazon Redshift?

Thanks!

[Stewart Bryson]

Yes. I've made this work. 

Sent from my iPhone

--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-met...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Jit Dutta]

What are the steps?

Thanks!

---

From: obiee-enterpri...@googlegroups.com <obiee-enterpri...@googlegroups.com> on behalf of Stewart Bryson <stewar...@gmail.com>
Sent: Monday, August 21, 2017 1:43 AM
To: obiee-enterpri...@googlegroups.com
Subject: Re: [OBIEE EMG] OACS and Redshift

 

[Stewart Bryson]

You'll have to enable ports in the compute config for OAC. You'll also have to either use the drivers shipped with DataDirect, or install the newer drivers provided by Amazon (preferred). In the latter case, the odbcinst.ini side of the setup is not required, as the Redshift driver already exposes its own config file, and loads classpath that way. 

I recommend using Redshift drivers, as DataDirect just uses Postgres drivers, and these are now spotty in supporting Redshift. 

Use the odbc.ini file in the bienv config location. 

Sent from my iPhone

[Jit Dutta]

Thanks Stewart!

---

From: obiee-enterpri...@googlegroups.com <obiee-enterpri...@googlegroups.com> on behalf of Stewart Bryson <stewar...@gmail.com>

Sent: Tuesday, August 22, 2017 4:57 AM

[Stewart Bryson]

Let me know how it goes.