Did your vendor and you consider building an ultra-secured interface that would take your SQL commands as input, and deliver the result dataSet into something like JSON that you can convert into the dataSet format that your DW layer uses?
You could just replace the calls to the SQL connection by a function that would identify whether you work local or cloud and call the suitable service. Thierry Nivelet FoxinCloud Give your VFP app a new life in the cloud http://foxincloud.com/ > Le 25 mai 2018 à 17:10, Stephen Russell <[email protected]> a écrit : > > Thanks. This is a viscous soup that is for sure and no real win one way or > the other for our team to go through. > > Right now I am writing up a spec on a test app that we could pull data from > them to us via API connectivity instead of a SQL connection. I'll then > write the APIs here and call them to pull data we need. > > One HUGE issue is that we utilize our DW for 99% of our internal app > processing instead of going against the raw data tables in the ERP. This > is our teams #1 point to overcome because we cannot just change a pointer > and query the NEW Analysis tool's data. Now we have to figure out how to > present our daily invoices to many customers via our portal, as well as > their orders that are going to be shipping in the next few days. That same > DW has 400+ reports as well as 9 data cubes that decisions are based > on daily. How long to recreate that content, and do we trust the values > being presented? We cannot tie against anything via the ERP for our > validation of new data. Talk about scaring the crap out of us! > > My gut tells me that this process will take 2 years for us to migrate fully > to the cloud. That ties up 5-6-7 people 30 hrs a week in a team of 12. > The team cannot make anything new as requested by various silo leadership > across the enterprise. That is NOT GOOD. > > Anyway, we are now doing more meetings just to attempt to learn what the > vendor can really do. I am not so uptight on DW as the others because > that will be a 100% mind shift on how we fill it going forward from what it > is today. That will take a lot of time for them and us to put together. > It goes against the ERP vendors path massively because they feel that what > they have will dow what everyone needs. So close but SO FAR off the mark. > > > > > > On Thu, May 24, 2018 at 4:15 PM, Paul H. Tarver <[email protected]> wrote: > >> I'm pretty sure that there are companies that can justify remoting their >> ERP >> otherwise there wouldn't be so many that do it. I just have seen and heard >> too many horror stories to make it a regular recommendation for my clients. >> No offense to the marketing people (I am one so I can say this), sometimes >> the sizzle is far better than the steak. >> >> It sounds like you have your hands full as well as a pretty good idea of >> the >> value of the external tools you've developed in-house to support the base >> product. Just don't let anyone else undervalue any of those external tools! >> >> I'll love to hear more as you guys progress through this and in particular >> some of the work arounds you end up doing to replace the custom tools >> you've >> built. I think it would a fascinating thread. >> >> Also, I'm sure everyone in the group is willing to try to assist if you >> need >> help or to vent! >> >> Paul H. Tarver >> >> -----Original Message----- >> From: ProfoxTech [mailto:[email protected]] On Behalf Of >> Stephen >> Russell >> Sent: Thursday, May 24, 2018 3:17 PM >> To: [email protected] >> Subject: [SPAM-LOW] Re: [NF] Let the meetings BEGIN. >> >> That is why we are actively looking at what we get and what we lose if we >> go this route. Our ERP loves the fact that we run on razor blades for them >> all the F'n time and they charge us less for doing all their dirty work. I >> have a 4-year-old ERP system on that list. :( >> >> For us to keep the latest version of the ERP is important. It has been >> talk of the department for the last 7 years I have been working here. In >> this case of it being on their HW, they have updates happening monthly. >> AWS is the environment. >> >> On Thu, May 24, 2018 at 9:30 AM, Paul H. Tarver <[email protected]> wrote: >> >>> There have been more than one of my clients who make the move to the >> cloud >>> only to find that key functionality that is required for their business >> to >>> function properly is lost. This might be due to loss of direct access to >>> their data, or worse, the cloud version of the ERP isn't nearly as >> complete >>> or mature as the self-hosted product. Either way, it costs way more than >>> just time and money. Sanity and common sense are often victims as well. >>> >>> No one has ever been able to satifactorily explain to me why remote >> hosting >>> your data on a server you do not control, in a place where you do not >> have >>> physical access, managed by people you did not hire, connected via a >>> service >>> provided by a third party provider with crappy customer service and paid >>> for >>> on a monthly fee basis was EVER a good idea for ANY business regardless >> of >>> the "benefits". >>> >>> Seems to me, it's like putting your data into a nursing home, trusting >> the >>> staff to feed and care for your data properly and hoping they keep your >>> data >>> in good shape so you can visit it once in a while. >>> >>> Paul H. Tarver >>> >>> >>> -----Original Message----- >>> From: ProfoxTech [mailto:[email protected]] On Behalf Of >>> Stephen >>> Russell >>> Sent: Wednesday, May 23, 2018 3:53 PM >>> To: [email protected] >>> Subject: [NF] Let the meetings BEGIN. >>> >>> Our ERP vendor wants us to jump into the cloud in a multi-tenant data >>> environment. >>> >>> Sucks for us having written many applications that read that data and >>> present it to users to get things done that the ERP doesn't do today. >>> >>> Apply monthly price updates on items due to what the contract has for >> that >>> customer. We then write those updates back to the ERP as well as send >> out >>> a notification letter to every customer about price updates. >>> >>> When your data is in THIS cloud you give up the right to query it. Do >> they >>> give access to APIs to pull what we need? Well they will think about >> that >>> is what I thought I just heard. >>> >>> Happy Happy Joy Joy it looks like the next 2 quarters are going to be >>> learning how to waste time on phone calls. >>> >>> -- >>> Stephen Russell >>> Sr. Analyst >>> Ring Container Technology >>> Oakland TN >>> >>> 901.246-0159 cell >>> >>> >>> --- StripMime Report -- processed MIME parts --- >>> multipart/alternative >>> text/plain (text body -- kept) >>> text/html >>> --- >>> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
