Data Source for IBM DB2 for Z/os mainframe

[nicola_jelmori1]

Using Power Query and Power Bi Designer, I have found that the connection to the IBM DB2 database is set to work for the Distributed version of DB2, and not for the Mainframe version. It would be possible to add the DB2 connection for the Mainframe Z/os?

[rgmolijn]

PS if addressing judge amounts of data on DB2 z/OS might want to consider using an accelerator on the DB2 z/OS env. It wil make your queries fly.

[rgmolijn]

DB2 Connect should do the job. Authorisation etc. is an internal issue to your organisation.

[TAJjbhunt]

can anyone elaborate on this error, what it is trying to tell me? Unable to connect: We encountered an error while trying to connect to devpjes2.jbhunt.com:5025. Details: "Cannot connect to the mashup data source. See error details for more information."Hide details Activity ID: 4ec2a540-d23e-76b7-458c-011d701d1642 Request ID: afe11ab9-60a3-def9-2bc9-0313f19290ec Cluster URI: https://wabi-us-north-central-redirect.analysis.windows.net Status code: 400 Error Code: DM_GWPipeline_Gateway_MashupDataAccessError Time: Tue Jul 19 2016 09:28:06 GMT-0500 (Central Daylight Time) Version: 13.0.1500.429 Underlying error code: -2147467259 Underlying error message: Microsoft Db2 Client: The host resource could not be found. Check that the Initial Catalog value matches the host resource name. SQLSTATE=HY000 SQLCODE=-360 DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.DataSourceKind: DB2 Microsoft.Data.Mashup.ValueError.DataSourcePath: devpjes2.jbhunt.com:5025;jbhdb2d Microsoft.Data.Mashup.ValueError.ErrorCode: 0 Microsoft.Data.Mashup.ValueError.Message: The host resource could not be found. Check that the Initial Catalog value matches the host resource name. SQLSTATE=HY000 SQLCODE=-360 Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error