topic Re: Connect Relationships - Exasol - Workflow in Alteryx Connect Discussions

Connect Relationships - Exasol - Workflow

BenMoss — Wed, 09 Jan 2019 17:01:52 GMT

I want to identify the cause as to why I am not seeing an automatically generated link between a datasource and the workflow that is generating that datasource.

The workflow itself is writing to an Exasol table using a 'saved data connection', which setup through the gallery interface uses a connection string that looks like...

ODBC:Driver={EXASolution Driver};uid=USERNAME; pwd=PASSWORD; EXAHOST=IP:PORT; database=DBNAME; exaschema=SCHEMANAME

When the workflow is loaded to connect I get the following...

I then use the Exasol loader with the following detail, and it loads successfully (note I have amended the loader to only load specific tables, which it does, and the statement is set to look include any records where the table_name is either NULL (because there is other detail away from table and column detail loaded), or where it matches, so I don't think that should cause an issue.)

And within connect it looks like...

So I would like to understand reasons why the connection/relationship may not have been established between the two sources (we used saved datasource connections/workflows/connect with our SQL Server and it works fine).

Potential things we could look at to try and establish the connection, and if that doesn't work, how to establish and maintain a manual connection, which I see is breifly discussed in this post, but not with a step by step guide (https://community.alteryx.com/t5/Alteryx-Connect-Knowledge-Base/Establishing-Relationships-Lineage-in-Connect/ta-p/313089).

Thanks in advance.

Ben

Re: Connect Relationships - Exasol - Workflow

OndrejC — Wed, 06 Feb 2019 14:42:27 GMT

Hi @BenMoss ,

this seems to be a problem in a way we are parsing connection string parameters from the workflow. Our engineering team is looking into that and will come back soon to you.

Ondrej

Connect Team

Re: Connect Relationships - Exasol - Workflow

TomasD — Mon, 11 Feb 2019 13:53:12 GMT

Hi @BenMoss ,
we did small improve in the Alteryx loader during connection parsing for Exasol and Oracle too.
In the current loader the connection string take the variable for IP/adrress like 'EXA Server' but this is for DSN only.
Connection string with using the Driver name uses for IP/address variable "EXAHOST" which is implemented to the workflow.
The similar think is for Oracle too, where was add variable "DBQ".

You can try to use attached Alteryx loader.

Best regards.

Tomas

Re: Connect Relationships - Exasol - Workflow

BenMoss — Mon, 11 Feb 2019 14:01:58 GMT

Thanks for taking your time to look at this @TomasD!

I will have a play with this new loader and give it a test :)

Ben

Re: Connect Relationships - Exasol - Workflow

BenMoss — Mon, 11 Feb 2019 14:19:31 GMT

Hi @TomasD,

Unfortunately it appears you have a nice shiny version of 2019.1 that we are yet to get our hands on! I tried downloading every asset to 2018.4 but that led to further issues.

Would you be able to send a version that is compatible with 2018.4 :)

Ben

Re: Connect Relationships - Exasol - Workflow

VojtechT — Mon, 11 Feb 2019 14:33:47 GMT

Hi @BenMoss ,

the 19.1 version should be available on Wednesday.

It should be also possible to get 19.1 version via the Beta program (beta.alteryx.com) - it's not the latest 19.1, but it is the one containing all needed tools, I believe. It should be there as part of Connect's Beta.

Vojta

Re: Connect Relationships - Exasol - Workflow

TomasD — Mon, 11 Feb 2019 15:31:19 GMT

Hi @BenMoss ,

please try again this version of loader changed to 18.4 version.

If you will do upgrade after release 19.1, you should use the previous file which I sended to you.

Tomas

Re: Connect Relationships - Exasol - Workflow

BenMoss — Mon, 11 Feb 2019 16:36:08 GMT

Thanks @TomasD; this works a charm, can you make sure you thank any others that worked on this problem on my behalf :)

Ben