RE: IBM i as datasource for MS PowerApps

When you connect, are you putting in "servername:446". I always have to do this in power bi for it to connect since it communicates over the DRDA port 446.

-----Original Message-----
From: Arco Simonse <arco400@xxxxxxxxx>
Sent: Thursday, August 23, 2018 2:08 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: IBM i as datasource for MS PowerApps

Hi Matt,

I have already tried the DB2 connector together with the on-premise gateway. But I can't get it connected, an I suppose that is because it is for DB2 LUW as Justin also mentioned.

Regards,
-Arco

Op do 23 aug. 2018 om 20:53 schreef Matt Olson <Matt.Olson@xxxxxxxx>:

Arco,

What you are looking for is here:
https://docs.microsoft.com/en-us/connectors/db2/

There is already built in support for DB2.

I think you want to be looking under the "Common Data Service"
section:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connectio
ns-list

We use Microsoft's DB2 connector in Power BI and it works pretty good.

Obviously your going to need to setup the onpremise data gateway so the cloud service can communicate with your IBMi.

Matt

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD