Forum Discussion

rriley99's avatar
rriley99
New Contributor III
2 years ago
Solved

Multiple Postgres DB

I have a postgres server that has about 5 different databases I want to consume, is it possible to parameterize the connection to pass the db_name like a table_name?   Thanks.
  • darshthakkar's avatar
    darshthakkar
    2 months ago

    Some of the observations here:

    1. Data coming from upstream systems was messed up

    2. There were added spaces in the data from the upstream systems itself 

    3. Ideally, with snapLogic, it should have been able to trim the spaces and help with the transformations however it wasn't able to do so

    4. Having said that, the mapper and conditional snap works just right for other set of data so giving the benefit of doubt to the messy data coming from upstream systems.

    Some recommendations/suggestions:

    1. If you're using a csv file, please ensure the encoding is supported in snapLogic and select the encoding accordingly

    2. For excel files, it should work just right

    3. For data coming from upstream systems like Oracle, Salesforce or Snowflake, try to export the data and see if there are any discrepancies, if there are, align with your team internally to fix it before connecting it with snapLogic.

    Closing this thread now.

virender_prajap's avatar
virender_prajap
New Contributor III
2 years ago
Copy LinkReport

Create a Postgres Dynamic Account and parameterized your credentials as needed.
Also ensure that the parameter which you have defined in the connection should be available in your pipeline with credentials.
During the execution your pipeline will send these credentials to the connection.