search

shabiel / M-Web-Server

A YottaDB and Caché compatible HTTP server
Apache License 2.0
24 stars 19 forks source link

Question #7

Closed jcc5169 closed 6 years ago

jcc5169 commented 7 years ago

Would like to use this with WorldVista to integrate with SQL Server SSIS using Web Service Task. Looking at what will need to be modified.

shabiel commented 7 years ago

Who's the producer and who's the consumer??

On Wed, Mar 29, 2017 at 12:45 PM, jcc5169 notifications@github.com wrote:

Would like to use this with WorldVista to integrate with SQL Server SSIS using Web Service Task. Looking at what will need to be modified.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/shabiel/M-Web-Server/issues/7, or mute the thread https://github.com/notifications/unsubscribe-auth/ABEtwietVhbFnw6E0T-gtlWrhkE6qKg7ks5rqrTugaJpZM4Mtdxu .

jcc5169 commented 7 years ago

I work at Central Regional Hospital for Joe Thurber and we have WorldVista implemented for about 5 years. Producer would be Vista, Consumer would be SQL Server 20212/2016 SSIS WebServices Task thru a http connection. Since our implementation is customized, anticipate some incompatibilities. If I run into them, will create a separate branch for mods and document alterations.

jcc5169 commented 7 years ago

Was trying to integrate thru C# calling RPC's using Medsphere dll's but SQL Server C# scripting in SSIS is too restricted to SQL Server. This looks like a more effective approach for querying VistA for data extraction.

jcc5169 commented 7 years ago

It is installed and working on port 9080, no problems so far

shabiel commented 7 years ago

Okay. I can probably help you more next week.

My email is sam dot habiel at the famous google email service. I have already written code to help you do what you want to do. If you are curious to get started, it's in the fileman-web repository on my github.

On Thu, Mar 30, 2017 at 9:02 AM, jcc5169 notifications@github.com wrote:

It is installed and working on port 9080, no problems so far

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/shabiel/M-Web-Server/issues/7#issuecomment-290458292, or mute the thread https://github.com/notifications/unsubscribe-auth/ABEtwr2OChOkZPujUhXQmESWni24T5LXks5rq9IhgaJpZM4Mtdxu .

jcc5169 commented 7 years ago

Sam,

Thanks for the response. I may not need help, in the process of looking at the pieces after installing it. Has nice possibilities ..... Thanks for offering, very kind of you.

From: Sam Habiel [mailto:notifications@github.com] Sent: Thursday, March 30, 2017 5:52 PM To: shabiel/M-Web-Server M-Web-Server@noreply.github.com Cc: Chris Combs ccombs@ens-nc.net; Author author@noreply.github.com Subject: Re: [shabiel/M-Web-Server] Question (#7)

Okay. I can probably help you more next week.

My email is sam dot habiel at the famous google email service. I have already written code to help you do what you want to do. If you are curious to get started, it's in the fileman-web repository on my github.

On Thu, Mar 30, 2017 at 9:02 AM, jcc5169 notifications@github.com<mailto:notifications@github.com> wrote:

It is installed and working on port 9080, no problems so far

- You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/shabiel/M-Web-Server/issues/7#issuecomment-290458292, or mute the thread https://github.com/notifications/unsubscribe-auth/ABEtwr2OChOkZPujUhXQmESWni24T5LXks5rq9IhgaJpZM4Mtdxu .

- You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttp://t.sidekickopen04.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XX46538ZRW3MPfxv5vfVJ-VRbxS056dH2Bf1B16yF02?t=https%3A%2F%2Fgithub.com%2Fshabiel%2FM-Web-Server%2Fissues%2F7%23issuecomment-290555887&si=4534763259428864&pi=5163ccbc-ab74-4602-9162-08d115bd1e30, or mute the threadhttp://t.sidekickopen04.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XX46538ZRW3MPfxv5vfVJ-VRbxS056dH2Bf1B16yF02?t=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAQf5QQsa9zJMNszvGEYXO113O_YLRQqBks5rrCQdgaJpZM4Mtdxu&si=4534763259428864&pi=5163ccbc-ab74-4602-9162-08d115bd1e30.

jcc5169 commented 7 years ago

Sam,

The description of what I want to add is here. https://en.wikipedia.org/wiki/Web_Services_Description_Language

shabiel commented 7 years ago

Holy crap... you want to create a WSDL? Dude, you are on your own. WSDLs are by and large deprecated... You only want to use them if you need to ingest .Net or Java data structures.

--Sam

On Tue, Apr 4, 2017 at 5:16 AM, jcc5169 notifications@github.com wrote:

Sam,

The description of what I want to add is here. https://en.wikipedia.org/wiki/Web_Services_Description_Language

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/shabiel/M-Web-Server/issues/7#issuecomment-291481688, or mute the thread https://github.com/notifications/unsubscribe-auth/ABEtwiuvcBdI6g4nb0EPXOJerVatZ0Pfks5rsjSCgaJpZM4Mtdxu .

jcc5169 commented 7 years ago

Sam,

I had already assumed I was "on my own". :) WSDL and SOAP are very much alive in the Microsoft world, so I am assuming you are talking about the non-Microsoft world when you say it has been deprecated. WSDL is just another mime type, and this service will use the building blocks you and others have already put into place. The producer mechanism is what has to be created. Will let you know how it goes. It will be an adventure, haven't been working with Mumps that long but I have great respect for the power and flexibility of the language.

Thanks, Chris Combs 919-602-1952

From: Sam Habiel notifications@github.com Sent: Tuesday, April 4, 2017 8:29 AM To: shabiel/M-Web-Server Cc: Chris Combs; Author Subject: Re: [shabiel/M-Web-Server] Question (#7)

Holy crap... you want to create a WSDL? Dude, you are on your own. WSDLs are by and large deprecated... You only want to use them if you need to ingest .Net or Java data structures.

--Sam

On Tue, Apr 4, 2017 at 5:16 AM, jcc5169 notifications@github.com wrote:

Sam,

The description of what I want to add is here. https://en.wikipedia.org/wiki/Web_Services_Description_Language

- You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/shabiel/M-Web-Server/issues/7#issuecomment-291481688, or mute the thread https://github.com/notifications/unsubscribe-auth/ABEtwiuvcBdI6g4nb0EPXOJerVatZ0Pfks5rsjSCgaJpZM4Mtdxu .

- You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/shabiel/M-Web-Server/issues/7#issuecomment-291484521, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AQf5QWyyjWIhFtu4qBT1IvrYBhpRa172ks5rsjeZgaJpZM4Mtdxu.