What is the best Oracle db connection format to use?

[Albert]

What is the best oracle db connection format to use in Alteryx?   ODBC /  OLEDB / OCI 

[KevinP · Accepted solution]

@Albert The preferred connection type is OCI. However, ODBC and OLEDB should both work as long as the Oracle drivers are properly configured with a valid TNSNames.ora file, and you correctly configure the connection strings.

[mborriero]

I simple connect to Oracle database using the Oracle function

If you follow the steps in this blog you will be able to connect without problem.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Connecting-to-Oracle-Alteryx-11-0/ta-p/46654