Some users may have issues creating a community account See more here.

sanbeam
Active participant

Does a business adapter support Mainframe connection?

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?

3 Replies
mfranz
Trusted advisor

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_d...

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

2020-11-02_18h26_19.png

Best regards,

Markward

Softline Group is Europe's leading independent expert in Software Asset Management.
kclausen
Flexera
Flexera

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
Active participant

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

0 Kudos