InfoSphere Optim

InfoSphere Optim

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  PostgresSQL as a Data Source

    Posted Fri May 10, 2019 04:50 AM
    Is anyone using PostgresSQL as a data source for archiving or masking?
    I am testing Foreign Data Wrapper for CSV masking. It was real easy to set up the FDW and table for a CSV, took about 2 minutes. BUT, isn't there always a but?

    We support running PostgresSQL servers at version 9.6 or 10.1 IBM supports 9.2 and 9.3 (9.3.4 is from 2014)
    as a data source. 

    Anyone using PostgresSQL, if so at what version?

    Any suggestions?

    ------------------------------
    Ed Lipson
    BNYMellon
    Brooklyn NY
    718 315 4763
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: PostgresSQL as a Data Source

    Posted Tue May 14, 2019 10:12 AM
    Hi Ed,

    I checked with the Optim support team and they have worked with several customers that are using PostgreSQL 9.4, 9.5, 9.6 and even 10 using the ODBC drivers that come with it. So in Optim, select 9.3 and use the aforementioned ODBC driver and you should be good.

    Regards,
    Rick

    ------------------------------
    Rick Spagna
    ------------------------------

    Original Message


  • 3.  RE: PostgresSQL as a Data Source

    Posted Tue May 14, 2019 10:17 AM

    I was using an ODBC connection on Windows for the test. So that would not help me.

     

     

     

    Thanks,

    Ed Lipson

    Director

    BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217

    Information Lifecycle Management

    T 718.315.4763 |  F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com

     


    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.



    Original Message


Related Content