Nicola Jelmorini on 02 Jul 2015 19:09:28
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?
- Comments (3)
RE: Data Source for IBM DB2 for Z/os mainframe
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
RE: Data Source for IBM DB2 for Z/os mainframe
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.
RE: Data Source for IBM DB2 for Z/os mainframe
DB2 Connect should do the job. Authorisation etc. is an internal issue to your organisation.