document-api-python icon indicating copy to clipboard operation
document-api-python copied to clipboard

Add Connection, NamedConnection and Relation classes

Open kgpayne opened this issue 4 years ago • 11 comments

New Connection, NamedConnection and Relation classes, added to support extraction of metadata via tap-tableau-server. From the readme:

tap-tableau-server is a Singer tap for Tableau Server, focused (currently) on extracting details embedded inside Workbook files. This includes Datasources, Connections and Relations, as well as retrieving table references from embedded Custom SQL text fields inside Relation entities.

Extracting the specifics of Datasources, Connections, Relations and Table References from each Workbook help answer questions like:

  • Which Workbooks depend on which tables in which databases?
  • How many Workbooks depend on Excel, CSV or Google Sheets?
  • Who's credentials are used for embedded connections, in which Workbooks?

Having answers to all of these questions has helped us with wrangling our Tableau Server instance, which is several years old and has over 1000 Workbooks.

In future, we hope to extend this tap to cover other metadata that is exposed by the Tableau Server API's directly (esp. Published Connections and child objects). PR submission very welcome. Watch this space!

kgpayne avatar Jun 29 '21 10:06 kgpayne

Interesting! Could you please submit a Contributor License Agreement described here: https://tableau.github.io/contributing.html?

jacalata avatar Sep 16 '21 23:09 jacalata

Any update on this? Would love to be able to use the new relation class.

bryceglarsen avatar Oct 29 '21 03:10 bryceglarsen

Unfortunately we absolutely can't merge code from someone who hasn't agreed to our CLA. Hopefully @kgpayne is still available and might come back to sign it and submit!

jacalata avatar Oct 30 '21 19:10 jacalata

But I can switch the PR to branch from development instead of master, and I'll try and add some tests for it so it's easier to finish if they do come back.

jacalata avatar Oct 30 '21 19:10 jacalata

Completely understandable @jacalata - wasn’t sure if CLA had been signed. Thank you though!

bryceglarsen avatar Oct 31 '21 05:10 bryceglarsen

Hey 👋 Thanks for checking this out! I recently moved roles, and am no longer at tailsdotcom/ to be able to sign an Organisational CLA on their behalf. However @alanmcruickshank might be able to 🙂 He is familiar with this work. I also don't have access to a Tableau instance anymore, so really appreciate your work on tests @jacalata 🙏

kgpayne avatar Nov 02 '21 10:11 kgpayne

Thanks for the contribution! Before we can merge this, we need @kgpayne to sign the Salesforce.com Contributor License Agreement.

salesforce-cla[bot] avatar Dec 16 '21 08:12 salesforce-cla[bot]

Hi @alanmcruickshank - are you interested/able to sign a CLA so I could merge this work into the tool? I don't think the bot is smart enough to understand that, so we might just need it over email.

jacalata avatar Mar 14 '22 23:03 jacalata

@jacalata - sure thing. Devraj Toor is our new tableau account rep so he can probably facilitate some document signing and has my email address 👍 .

alanmcruickshank avatar Mar 21 '22 17:03 alanmcruickshank

I finally actually pinged Dev so hopefully will get this wrapped up soon

jacalata avatar May 24 '22 20:05 jacalata

Any updates here? Am interested in the relation class too.

waltonereed avatar Aug 04 '22 17:08 waltonereed

Closing as approaching 2 years old and very stale 🤷‍♂️

kgpayne avatar Feb 08 '23 15:02 kgpayne