Richard,
Thanks for the feedback. I'm not sure what type of connection we have with the Azure environment. I'll have to ask about that. I am curious about how durable the ODBC connection would be. I would prefer the REST API approach myself.
Dean Eshleman
Software Development Architect
Everence
1110 North Main Street
PO Box 483
Goshen, IN 46527
(800) 348-7468 ext. 3528
(574) 533-9515 ext. 3528
[Join our Talent Network]<
http://www.everence.com/careers>
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Richard Schoen
Sent: Friday, February 4, 2022 1:59 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: [EXTERNAL] RE: DRDA and Azure SQL Server
This email originated outside of Everence. Do not click links or attachments unless you recognize the sender.
Direct connect would require IBM i access ODBC drivers most likely and using the SQL Server linked server.
This has always been dicey and probably more-so over Internet because you would have to maintain an ongoing ODBC connection to IBMi.
I would say REST services is probably a better way of doing things for realtime.
Do you have a VPN connect between Azure and your local network ?
Regards,
Richard Schoen
Web:
http://www.richardschoen.net<
http://www.richardschoen.net>
Email: richard@xxxxxxxxxxxxxxxxx<mailto:richard@xxxxxxxxxxxxxxxxx>
------------------------------
message: 3
date: Fri, 4 Feb 2022 18:37:19 +0000
from: Dean Eshleman <Dean.Eshleman@xxxxxxxxxxxx<mailto:Dean.Eshleman@xxxxxxxxxxxx>>
subject: DRDA and Azure SQL Server
Hi,
We are on 7.3 of IBM i. We are working on a project where an application in Azure will need to update some tables on the IBM i. Our initial thought was to create REST API's on the IBM I and have the Azure application call them. We have experience with REST API's, so we understand how that would work. The consultants we are working with (Windows background) ran across DRDA and wondered if they could use that to connect directly to the database on the IBM I and skip the REST API. The thinking being, that would be less work. I did some reading about DRDA, but it wasn't very clear to me how it works. Does anyone have experience using DRDA in this manner? I guess I would also be interested in reasons why this may not be a good idea. TIA
Dean Eshleman
Software Development Architect
Everence
1110 North Main Street
PO Box 483
Goshen, IN 46527
(800) 348-7468 ext. 3528
(574) 533-9515 ext. 3528
[Join our Talent Network]<
http://www.everence.com/careers>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l<
https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/midrange-l<
https://archive.midrange.com/midrange-l>.
Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com<
https://amazon.midrange.com>
Confidentiality Notice: This information is intended only for the individual or entity named. If you are not the intended recipient, do not use or disclose this information. If you received this e-mail in error, please delete or otherwise destroy it and contact us at (800) 348-7468 so we can take steps to avoid such transmission errors in the future. Thank you.
midrange.com
