I have heard, from someone who should know, that Vantage is written
over a load of 4GL code which works directly with Progress. Epicor
are rewriting this code in a non-database specific form and hope to
have it ready for v9 late next year. V9 will also have much improved
financials as much of the iScala functionality will also be
incorporated.
Because of the current 4GL code, when working on SQL Vantage actually
asks Progress for the data as normal, but Progress then runs ODBC
queries off the SQL database.
One of the engineers looking after us is currently involved in an SQL
installation. His opinion is that SQL is slower than Progress because
of this.
over a load of 4GL code which works directly with Progress. Epicor
are rewriting this code in a non-database specific form and hope to
have it ready for v9 late next year. V9 will also have much improved
financials as much of the iScala functionality will also be
incorporated.
Because of the current 4GL code, when working on SQL Vantage actually
asks Progress for the data as normal, but Progress then runs ODBC
queries off the SQL database.
One of the engineers looking after us is currently involved in an SQL
installation. His opinion is that SQL is slower than Progress because
of this.
--- In vantage@yahoogroups.com, "Dave Thomas" <dthomas@...> wrote:
>
> My own opinion is that the SQL database will dominate at Epicor in
> the not too distant future. Progress Software has been emphasizing
> their development tools and app server technology in the past few
> years, realizing that SQL Server and Oracle have become the
industry
> standards for database technology. I have done benchmarking on the
> performance of Vantage 8 on SQL and Progress and have not seen
> significant differences. This is consistent with everything I have
> heard from the technical people at Epicor. I do believe that the
> server hardware specs published by Epicor for SQL are on the low
> side. SQL runs better with lots of RAM. Also, according to Epicor,
> 8.03.400 will support native access to SQL, I assume without the
> schema holders, so any small performance advantgage currently held
> by Progress will probably disappear in the near future.
>
> Further down the road in version 9, Epicor is going to consolidate
> their Enterprise (non-manufacturing) ERP product onto the Vantage
> platform. That user base is 100% SQL. I don't think many of them
> are going to convert to Progress, so within a few years, the
> majority of Epicor users will be on SQL, not Progress. I don't
> doubt that Progress is a very competent database, but the toolset
> that comes with SQL (including the ODBC driver) is far superior to
> what you get with Progress, and the advantages of being on the
> industry standard database are huge.
>
>
>
>
> --- In vantage@yahoogroups.com, "Jason Claggett" <jason@> wrote:
> >
> > Bruce,
> >
> >
> >
> > There are some Progress "connectors" (Epicor refers to them as
> schema
> > holders) that are put in the mfgsys803/db folder that do the
> > redirecting. Although the performance hit is not as bad as it was
> in V6,
> > this is just another place where something can break and another
> step in
> > the troubleshooting process when there is a problem.
> >
> >
> >
> > Bottom line is, Epicor development needs to write individual
> connection
> > interfaces for each type of database they want to support
> otherwise you
> > will always be a slave to Progress.
> >
> >
> >
> > Most of our customers go with Progress, but there have been a
> couple
> > that have chosen SQL - mostly because they had the SQL knowledge
> > already. One of them actually PAID Epicor to convert their data
> from SQL
> > to Progress after they went live because it was running way too
> slow.
> >
> >
> >
> > Thanks,
> >
> >
> >
> > Jason Claggett
> >
> > Microsoft Small Business Specialist
> >
> > MCP #3856159
> >
> > 2W Technologies, LLC
> >
> > 312.533.4033 x8039
> >
> > jason@
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of Bruce Butler
> > Sent: Friday, August 17, 2007 8:46 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] MS-SQL vs Progress - V8 and beyond
> >
> >
> >
> > I asked our customer rep this exact question. His official (maybe
> > unofficial, not sure) stance was Epicor and Progress have deep
> roots,
> > and in no way was Epicor going to stray away from Progress.
> >
> > He also stated even though the working platform is SQL for those
> who
> > chose SQL, Progress is still conducting the flow. I do not know
> what or
> > how that works technically. There is actually a performance hit
> due to
> > this. So the SQL install should at least theoretically run slower
> than
> > Progress setup.
> >
> > It seems the majority of the newer features incorporated from
> Epicor
> > buy-outs run on MS-SQL. With that, I have to wonder for how long
> will
> > the core product be able to stand up to the pressure of the SQL
> add-ons.
> > Eventually it seems either the addons or the core will need to be
> > rewritten for a unified platform.
> >
> > Bruce Butler
> >
> > IT Manager
> >
> > Knappe & Koester, Inc.
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > [mailto:vantage@yahoogroups <mailto:vantage%
> 40yahoogroups.com> .com] On
> > Behalf Of
> > Todd Anderson
> > Sent: Tuesday, August 07, 2007 9:59 AM
> > To: 'Vantage @ YahooGroups. Com'
> > Subject: [Vantage] MS-SQL vs Progress - V8 and beyond
> >
> > Can I ask what the current thoughts are about MS-SQL vs Progress
> for the
> > DB
> > under V8 and for V9-V10-V11-V12 etc in the future.
> >
> > V6.1 and prior was, what, 99.2% Progress.
> >
> > With V8 it seems like the tide hasn't decided which way it wants
to
> > go...
> >
> > At first it seemed like most folks were planning on staying with
> > Progress.
> > Then it seemed like SQL was selling on most new accounts.
> > Now it seems like some folks are drifting back to Progress for
> > performance
> > issues.
> >
> > A company yesterday said they were sold the system with MS-SQL
and
> the
> > sales
> > rep made NO mention that Progress was an alternative. Now they are
> > wondering if that was the right decision.
> >
> > Does ANYONE have a clue or an opinion on how this is going to
play
> out
> > over
> > the next 5 years?
> >
> > As the customer said yesterday ... He doesn't want to install
> Progress
> > and
> > then have to switch to SQL in the next 3 years ... or vice versa.
> >
> > Truly - I'd appreciate any feed back I can get on this.
> >
> > Thanks,
> >
> > Todd Anderson
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>