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:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, May 24, 2018 3:17 PM To: profoxtech@leafe.com 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 paul@tpcqpc.com 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:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Wednesday, May 23, 2018 3:53 PM To: profoxtech@leafe.com 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]
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 paul@tpcqpc.com 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:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, May 24, 2018 3:17 PM To: profoxtech@leafe.com 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 paul@tpcqpc.com 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:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Wednesday, May 23, 2018 3:53 PM To: profoxtech@leafe.com 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]
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 srussell705@gmail.com 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 paul@tpcqpc.com 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:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, May 24, 2018 3:17 PM To: profoxtech@leafe.com 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 paul@tpcqpc.com 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:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Wednesday, May 23, 2018 3:53 PM To: profoxtech@leafe.com 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]
On Sat, May 26, 2018 at 4:50 AM, Thierry Nivelet tnivelet@foxincloud.com wrote:
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.
It is a multi-tenant environment so that is not available. We have a data lake but I am not sure what is there as of yet. Our current data is 1.2 TB now and I hope they take what we have and normalize it finally but we would never know would we. :)
In my mind we just have them create APIs that do what we want and all is good.
-
Paul H. Tarver -
Stephen Russell -
Thierry Nivelet