Skip to main content
Released

Expose access to Database|Web Connections via FMEObjects

Related products:Transformers
  • September 13, 2016
  • 6 replies
  • 166 views

tino
Supporter
Forum|alt.badge.img+26

It is currently not possible to access the database|web connections (username, password, host,etc.) with FMEObjects.

Usage scenario:

In the Python Startup Script (Scripted Parameters, PythonCaller, PythonCreator, Shutdown Script) we want to access an Oracle database via cx_oracle. While the Oracle Reader/Writer can use a Named Connection we have to expose additional parameters for our python scripts to be able to connect to the database.

Please expose functions in (Python) FMEObjects to be able to use existing Database|Web Connection details.

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.

6 replies

geosander
Forum|alt.badge.img+7
  • October 11, 2017

Just wanted to create this idea, but it already exists! :)

Yes, this would be great for all those people (like me) who need to access some database or API using Python and want to use a safe and dynamic way to obtain the connection properties and credentials. Now, this needs to be hard-coded or passed via published/private parameters, like @tino said.


david_r
Celebrity
  • June 17, 2020

nic_ran
Contributor
Forum|alt.badge.img+17
  • Contributor
  • June 19, 2020

Looks like this *may* be getting some love from Safe (fingers crossed). If so, while you're in there, maybe you can also implement this:

https://knowledge.safe.com/idea/101822/expose-web-connection-details-in-workspace.html

 


david_r
Celebrity
  • June 19, 2020

Thanks for sharing, am crossing my fingers.


peter_s
Contributor
Forum|alt.badge.img+4
  • Contributor
  • February 4, 2021

tino
Supporter
Forum|alt.badge.img+26
  • Author
  • Supporter
  • June 17, 2024