We would like to push Essbase data from one of our ASO cubes to RedShift. Per Oracle, Redshift is not supported by Essbase. Has anyone found another way to make this happen? I'm thinking maybe we could use Informatica as the go-between??
Our goal is to get the Essbase data into a virtual data mart (JBoss Data Virtualization). Does Essbase have any options for this, assuming we use something aside from RedShift?
Also, is it possible for Essbase to read from or write to a Google Sheet? I know if we exported a Google sheet into a CSV file, Essbase could read it using a load rule, but wanted to see if Essbase could integrate directly w/ Google to receive or send data from a Google sheet.
Thanks!
Terri T.