See all objects reading from or writing to table

[jensroy]

Hello,

Is it possible to open a database table in connect, and then see all alteryx workflows that output to that table or read from it?

If I open a workflow I can see the database table output, but if I open the table, i do not see related Alteryx workflows.

[VojtechT]

Hi @jensroy ,

that is weird, because that's exactly how it's supposed to work. 

Do you have any other objects in the lineage? The Nexus diagram can be quite resource demanding and thus there is a limit of how many objects are visible in the diagram. But underneath the diagram all the related objects should be listed.

workflow->table

table->workflow

[OndrejC]

Hello @jensroy ,

yes this should be standard functionality of Connect.

Supposing you have the latest version of Connect (19.3) when you go to a workflow page you should see relatinships visually represented and also in the table view (see attached screenshot).

And when you click on the table (on the diagram or in the table view) you will again see relationship visually and in table view (see another screenshot).

Of course you need to make sure that you have loaded database under the same name (e.g. oracle.acme.com) as it is used in your workflow.

If you still having troubles, pls share your findings / screenshots so we can help you to debug.

Ondrej

Connect Team