0 Replies Latest reply on Aug 30, 2016 2:20 PM by 3182852

    ODBC Unable to locate SQLGetPrivateProfileString function - OBIEE 12C & AWS Redshift

    3182852

      Hello Everyone,

       

      Hoping someone can help me.

       

      We have set up an OBIEE 12C instance and want to connect it to AWS Redshift DB.

       

      Have confingured the Linux box following the following guide but replacing with the Redshift Driver:

      http://www.rittmanmead.com/blog/2016/08/using-apache-drill-with-obiee-12c/

       

      The RPD connects to the DB and I can view data through this.

       

      I can also query the DB using the iSQL command so we know the BI Server can talk to the Redshift DB.

       

      But in Answers this message is not going away, I feel like I have tried everything and am pulling my hair out!!!

       

      Feel free to ask for contents of any files just please let me know the exact paths of the files. (odbc.ini, odbcinst.ini etc...)

       

      Thanks,

       

      Punit