Skip to main content
Question

How can we access AWS secret keys for connecting to database in FME workbench?

  • September 12, 2023
  • 2 replies
  • 96 views

bhagyashrisingh
Forum|alt.badge.img

I don't want to make database connection by giving hardcoded values instead I want to use the secret keys from secret manager. is there any way to implement this in FME ?

2 replies

j.botterill
Influencer
Forum|alt.badge.img+34
  • Influencer
  • September 12, 2023

Hi there,

You will need to connect to AWS via a "web connection". Once you have this configured/authenticated, drop a S3Connector transformer onto the canvas and tell it to use web connection

https://docs.safe.com/fme/2022.2/html/FME_Desktop_Documentation/FME_Transformers/Transformers/s3connector-pkg.htm


bhagyashrisingh
Forum|alt.badge.img

thanks j.botterill for quick response, so for example in my workspace I need to connect POSTGIS database for writing the table in target database (i.e. PostGIS db) and after connecting to PostGIS db I need to select particular schema for writing the table for that I need to connect the database but not through usual database connection we are using in FME, I need to use secret values for connecting the database. As per your suggestion I need to make web connection first & then need to use S3 connector transformer but in S3 connector can we select schema that we are generally doing in normal database connection in FME.


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