Does a business adapter support Mainframe connection?

[sanbeam]

Dear Community,

 I am trying to integrate FNMS with PeopleSoft to have purchase order details uploaded. The PeopleSoft team have their data on a Mainframe DB2 database. Does the business adapter support a connection to DB2 databases? If it does not, what other options can I consider?

[mfranz]

Hi,

You'll need DB2 database drivers, most likely OLE or ODBC.
https://www.ibm.com/support/knowledgecenter/en/SS6NHC/com.ibm.swg.im.dashdb.doc/connecting/connect_driver_package.html

And you'll need network access, as well as a proper credentials with enough rights to login and access relevant tables and views.

Best regards,

Markward

[kclausen]

As an alternate method, you can write a Mainframe program/job that extracts the data that is needed from the PeopleSoft/DB2 back end, and create a delimited CSV flat file on a shared volume on your network.  You can then write a Business Adapter that reads from this CSV file and imports the purchase data into FlexNet Manager.

[sanbeam]

Thank you both for the inputs. I will try out and see which works best for my environment.