Skip to main content
Question

Retrieving all connections from a workspace

  • February 4, 2019
  • 3 replies
  • 118 views
R
Forum|alt.badge.img

Hi,

I need to update a database model which has a lot of fme jobs associated with it. So I would like to extract all connections made by all our workspaces and make a little data model of all fme jobs and associated connections. I get some info out of the fmw reader but there are connections made by sql statements (and pl/sql) as well which as I see it now would need sql parsing.

Is there any alternative for going down the python route? Cause I would to need learn something I hardly use and thus forget. Administering fme jobs this way would make it possible to gather more quickly where to update the fme jobs after a data model change. Any alternative transformer to the python caller? Any alternatives to the fmw reader? Any workflows you guys use to organize that forest of jobs?

All the best, Robbert

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

xiaomengatsafe
Safer
Forum|alt.badge.img+11

Hi rokop, Although I don't know of an alternative method to achieve what you wanted, I did find this idea, which when implemented will make your life a bit easier. Just wanted to let you know, since you may be interested in voting for it and following it's progress. https://knowledge.safe.com/idea/86335/search-find-for-all-workbenches-that-contains-a-sp.html

M
Forum|alt.badge.img+2
  • markatsafe
  • February 5, 2019

With a bit of configuration, the workspace reader (FMW) should be able to return a list of the connection files in a workspace. I've attached an example workspace: databaseconnectionnames.fmw

R
Forum|alt.badge.img
  • rokop
  • Author
  • February 6, 2019

Thanks Mark,

This is exactly what I was working on indeed. I will try adapt it a bit for retrieving schema objects as well and make it batch run with the workspace runner. It is the SQL parser which could be run over the "SQL_STATEMENTS" attribute which is the biggest obstacle however. But hey seems I will have to give Python a go then.

Cheers, Robbert

Helpful Members This Week

Community Stats

31,927
Posts
121,264
Replies
39,553
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.