Skip to main content
  • Home
  • Ideas
  • Expose access to Database|Web Connections via FMEObjects
Released

Expose access to Database|Web Connections via FMEObjects

Related products:Transformers
  • September 13, 2016
  • 6 replies
  • 79 views
tino
Contributor
  • tinoContributor
  • Contributor

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 a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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
  • geosander
  • 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
Evangelist
  • david_rEvangelist
  • June 17, 2020

See also https://knowledge.safe.com/idea/32677/provide-access-to-named-connections-in-pythoncalle.html?childToView=115746

 

nic_ran
Contributor
Forum|alt.badge.img+16
  • nic_ranContributor
  • 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
Evangelist
  • david_rEvangelist
  • June 19, 2020

Thanks for sharing, am crossing my fingers.

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

https://community.safe.com/s/idea/0874Q000000j0SHQAY/detail

tino
Contributor
Forum|alt.badge.img+16
  • tinoContributor
  • Author
  • Contributor
  • June 17, 2024

This has been available for quite some time:

https://docs.safe.com/fme/html/fmepython/api/fmewebservices/index.html

Most helpful members this week

Community Stats

30,846
Posts
116,941
Replies
38,670
Members
Terms & ConditionsCookie settings

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.