Connecting to Smartsheet from Oracle Analytics Desktop 12c

Manish Hathi · 03/30/20

Hello,

Has anyone successfully connected to Smartsheet from Oracle Analytics Desktop 12c?

I have installed the Smartsheet live data connector, created a 64 bit ODBC Connection (DSN), tested from within Excel. It works. Now I want to connect directly from a data visualization tool (Oracle's Analytics Desktop 12c) and I am unable to save connection with an error that invalid hostname or port.

Any insights would be helpful.

Thanks,

Manish

Genevieve P. · 04/01/20

Hi Manish,

I personally have never tried to connect Oracle Analytics with Smartsheet using ODBC. If you're receiving an error, I would suggest reaching out to Smartsheet Support (here).

You can find the full documentation for ODBC here: http://smartsheet-platform.github.io/odbc-docs

Cheers,

Genevieve

Anita Basa · 12/03/20

Hello,

I also never tried to connect oracle Analytics but i found one link, please check, i think it will be useful

https://docs.oracle.com/en/database/oracle/oracle-database/19/adfns/odbc-driver.html#GUID-7931EDFB-7A70-4BBE-903E-8A2BB09DBE9D

If any one want to learn more about oracle, click on this link: https://mindmajix.com/oracle-ebs-training

Thanks & Regards,

Anita

Connecting to Smartsheet from Oracle Analytics Desktop 12c

Answers

Categories