Connecting to Corptax ODBC

Does anyone have any experience connecting to Corptax ODBC? I have added the Corptax ODBC Driver but can not connect. The connection Error I am receiving is

ERROR [08001][Corptax][ODBC] (103800 Unable to establish a connection with data source. Missing settings: {[contextName]}

Database Connection

Accepted answers

AshleenKenney

Attached are connection instructions received from Corptax. This worked for me.

Using-Alteryx-with-ODBC.pdf

All comments

DanM

@AshleenKenney,

Just to make you aware, Corptax is not a supported data source for Alteryx, so you may not be able to connect to it. If you would like to see this added as a Data Source please add your Idea to the Designer Ideas board.

Thanks

DanM

AshleenKenney

Hi Dan,
Thanks for your response. I was recently at a KPMG/Corptax training session and they were displaying this Corptax ODBC0-Alteryx connection functionality so I know connection is possible. I spoke with a Corptax Support Rep this morning and they are working on sending me specific setup instructions for connecting. Are you just saying it is not a supported data source meaning connection could be possible but without support?

[Verizon]

Ashleen E. Kenney
Tax Manager | Verizon Lean Six Sigma Black Belt | CSC Corptax Certified Professional

900 Race Street, 6th Floor
Philadelphia, PA 19107

O 267.768.6063 | M 215.805.8844
ashleen.e.timoney@verizon.com

[Twitter] [Instagram]

AshleenKenney

Attached are connection instructions received from Corptax. This worked for me.

Using-Alteryx-with-ODBC.pdf

simonaubert_bd

Hello @AshleenKenney

one solution would be to use Generic ODBC connection. There are some ideas about it to improve this specific feature :
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Generic-in-memory-odbc-connection-please-stop-inventing-and/idi-p/977722

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Data-Connection-Manager-DCM-please-add-generic-ODBC-oledb/idi-p/962598

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Generic-In-database-connection-please-stop-inventing-and/idi-p/359763

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Generic-In-database-connection-ability-to-change-the-field/idi-p/414435

Also, maybe an update of the Visual Query Builder component would help (it's a third-party component) :
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Update-Query-Builder-component/idi-p/799086

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703