Connecting to Oracle OBIEE Respository Data

I'm fairly new to Alteryx and our team uses OBIEE and has done years of transforming data to sanctioned Oracle OBIEE repository layers. I would like to be able to connect directly to the OBIEE repositories rather then trying to recreating everything in Alteryx and connecting directly to the db.

Has anyone had success or have any tips on how to connect directly to OBIEE repositories?

Dan

Database Connection

Accepted answers

DiganP

Hi @danielreedsmith

I've never seen it done but I found this in the Oracle documentation: https://docs.oracle.com/cd/E25054_01/bi.1111/e16364/odbc_data_source.htm#CIABFJBA

Sounds like that driver allows you to pick a repository to connect to.

All comments

DiganP

Hi @danielreedsmith

I've never seen it done but I found this in the Oracle documentation: https://docs.oracle.com/cd/E25054_01/bi.1111/e16364/odbc_data_source.htm#CIABFJBA

Sounds like that driver allows you to pick a repository to connect to.

danielreedsmith

Thank you! This at least gives us a direction to try. I touched base with our Technical lead at Alteryx and they suggested the same thing.

If we can make it work I'll share with the group!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317