Pervasive or other data integration tools

I would like to thank everyone who offered their input. It has really
been helpful in our decision making process, which is still deciding
but we're closer to an answer than before!

--- In vantage@yahoogroups.com, "S. Michael Reeves" <mreeves@...> wrote:
>
> Hello wide and varied folks of the manufacturing or other
> like-industries! My company and myself have a quick question to ask
> you fine folks in regards to your experience in data integration with
> Epicor Vantage, (Preferably 8.03.4xx, although any experience shared
> is definitely welcome, especially since it could help others).
>
> We are currently in the Epicor implementation process but we're
> wondering what the best method in converting our data, (that can
> easily be placed into XLS and uses and ODBC connection to do so), from
> the legacy program to Epicor Vantage. I know that Epicor offers their
> data integration services where we use their data conversion sheets
> and they go ahead and do it for us, but we're also looking towards the
> future. Would it be worth purchasing a program such as Pervasive and
> doing it ourselves? Is there any other success stories that do it
> differently?
>
> Just any data integration/migration experience using Epicor would be
> greatly appreciated!
>
> Thanks a ton!!!
> --Mike Reeves
>
Hello wide and varied folks of the manufacturing or other
like-industries! My company and myself have a quick question to ask
you fine folks in regards to your experience in data integration with
Epicor Vantage, (Preferably 8.03.4xx, although any experience shared
is definitely welcome, especially since it could help others).

We are currently in the Epicor implementation process but we're
wondering what the best method in converting our data, (that can
easily be placed into XLS and uses and ODBC connection to do so), from
the legacy program to Epicor Vantage. I know that Epicor offers their
data integration services where we use their data conversion sheets
and they go ahead and do it for us, but we're also looking towards the
future. Would it be worth purchasing a program such as Pervasive and
doing it ourselves? Is there any other success stories that do it
differently?

Just any data integration/migration experience using Epicor would be
greatly appreciated!

Thanks a ton!!!
--Mike Reeves
We are nearing our go live date (6/9) and took the route of purchasing
and using the Pervasive tool.



I have gone through about 6 conversions during our implementation and
have found the product to work well.



We opted to purchase the professional edition directly from Pervasive.
What we found is that the version sold by Epicor is less expensive but
also lacks many of the data connectors which would make the tool useful
in the long term.



Our approach involved using the test database as a baseline for each
import. The baseline includes released customizations, import of
non-changing data, company setup, etc. We then copy the test to pilot
and perform the reimport to pilot. A tightly controlled access
procedure to the test database has been necessary and a careful
regulated development process to ensure that customizations, BAQ's, etc.
make it into the test database once test and approved.



I have had to develop a four page procedure to follow during the import
process to ensure all steps are completed correctly, data cleansing is
done, post updates are run, etc. I found that while the maps and
templates work well there is no help for understanding the sequence that
is necessary and various and sundry quirks and extra imports/updates
that were necessary to really get the system functional. I'm very happy
that we went this route because we would never have gotten as much data
across and the system functionality to the point we have by getting a
standard conversion done.



You're welcome to contact me directly if you would like to discuss
further.



John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)





[Non-text portions of this message have been removed]
Mike,

We went live with v8.03.403D (Accounting modules only) on February 1st,
2008. Our approach was nearly identical to John's. We purchased the Data
Integrator directly from Pervasive to get the expanded set of adaptors and
programming tools. We had several legacy systems and this tool allowed us
to merge data from multiple systems very easily. We imported suppliers,
purchase points, customers and shipto ID's using the Data Integrator. We
used Excel to copy and paste for most of the other Accounting related setup
files.

We intend to use Data Integrator to import Parts, Contacts and Employees as
we move forward with activating more modules.

Pervasive's Data Integrator is a great tool, I highly recommend it! We
changed our chart of accounts #'s, terms codes, sales rep codes, customer
codes, supplier codes and many other things during our conversion. I don't
see how we could have smoothly managed that much change in such a short time
period without the Data Integrator.

Good Luck!

Dan Snyder
IT Manager
Mercury Electronics
717-428-0222 ext.224


_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Hatcher, John
Sent: Thursday, May 22, 2008 8:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re:Pervasive or other data integration tools...



We are nearing our go live date (6/9) and took the route of purchasing
and using the Pervasive tool.

I have gone through about 6 conversions during our implementation and
have found the product to work well.

We opted to purchase the professional edition directly from Pervasive.
What we found is that the version sold by Epicor is less expensive but
also lacks many of the data connectors which would make the tool useful
in the long term.

Our approach involved using the test database as a baseline for each
import. The baseline includes released customizations, import of
non-changing data, company setup, etc. We then copy the test to pilot
and perform the reimport to pilot. A tightly controlled access
procedure to the test database has been necessary and a careful
regulated development process to ensure that customizations, BAQ's, etc.
make it into the test database once test and approved.

I have had to develop a four page procedure to follow during the import
process to ensure all steps are completed correctly, data cleansing is
done, post updates are run, etc. I found that while the maps and
templates work well there is no help for understanding the sequence that
is necessary and various and sundry quirks and extra imports/updates
that were necessary to really get the system functional. I'm very happy
that we went this route because we would never have gotten as much data
across and the system functionality to the point we have by getting a
standard conversion done.

You're welcome to contact me directly if you would like to discuss
further.

John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)


.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msgId=6
5148/stime=1211459779/nc1=4507179/nc2=3848644/nc3=5191954>



[Non-text portions of this message have been removed]
How much did Data Integrator cost when purchased directly from
Pervasive?



Joe Rojas

Information Technology Manager

Symmetry Medical New Bedford

P: 508.998.4575

C:508.838.4717

F:508.995.9597

joe.rojas@... <mailto:joe.rojas@...>



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Snyder
Sent: Thursday, May 22, 2008 9:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re:Pervasive or other data integration tools...



Mike,

We went live with v8.03.403D (Accounting modules only) on February 1st,
2008. Our approach was nearly identical to John's. We purchased the Data
Integrator directly from Pervasive to get the expanded set of adaptors
and
programming tools. We had several legacy systems and this tool allowed
us
to merge data from multiple systems very easily. We imported suppliers,
purchase points, customers and shipto ID's using the Data Integrator. We
used Excel to copy and paste for most of the other Accounting related
setup
files.

We intend to use Data Integrator to import Parts, Contacts and Employees
as
we move forward with activating more modules.

Pervasive's Data Integrator is a great tool, I highly recommend it! We
changed our chart of accounts #'s, terms codes, sales rep codes,
customer
codes, supplier codes and many other things during our conversion. I
don't
see how we could have smoothly managed that much change in such a short
time
period without the Data Integrator.

Good Luck!

Dan Snyder
IT Manager
Mercury Electronics
717-428-0222 ext.224

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Hatcher, John
Sent: Thursday, May 22, 2008 8:36 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re:Pervasive or other data integration tools...

We are nearing our go live date (6/9) and took the route of purchasing
and using the Pervasive tool.

I have gone through about 6 conversions during our implementation and
have found the product to work well.

We opted to purchase the professional edition directly from Pervasive.
What we found is that the version sold by Epicor is less expensive but
also lacks many of the data connectors which would make the tool useful
in the long term.

Our approach involved using the test database as a baseline for each
import. The baseline includes released customizations, import of
non-changing data, company setup, etc. We then copy the test to pilot
and perform the reimport to pilot. A tightly controlled access
procedure to the test database has been necessary and a careful
regulated development process to ensure that customizations, BAQ's, etc.
make it into the test database once test and approved.

I have had to develop a four page procedure to follow during the import
process to ensure all steps are completed correctly, data cleansing is
done, post updates are run, etc. I found that while the maps and
templates work well there is no help for understanding the sequence that
is necessary and various and sundry quirks and extra imports/updates
that were necessary to really get the system functional. I'm very happy
that we went this route because we would never have gotten as much data
across and the system functionality to the point we have by getting a
standard conversion done.

You're welcome to contact me directly if you would like to discuss
further.

John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)

.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
Id=6
5148/stime=1211459779/nc1=4507179/nc2=3848644/nc3=5191954>


[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
The approach being discussed sounds a lot like our plan to re-implement Vantage, treating 6.1 as a legacy system. For the Data Integrator direct form Pervasive what would be a ball park cost? Our biggest reason for re-implementing fom scratch and importing "base" data is to completely re-work our Chart of Accounts.

Thanks,
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Dan Snyder
Sent: Thursday, May 22, 2008 8:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re:Pervasive or other data integration tools...


Mike,

We went live with v8.03.403D (Accounting modules only) on February 1st,
2008. Our approach was nearly identical to John's. We purchased the Data
Integrator directly from Pervasive to get the expanded set of adaptors and
programming tools. We had several legacy systems and this tool allowed us
to merge data from multiple systems very easily. We imported suppliers,
purchase points, customers and shipto ID's using the Data Integrator. We
used Excel to copy and paste for most of the other Accounting related setup
files.

We intend to use Data Integrator to import Parts, Contacts and Employees as
we move forward with activating more modules.

Pervasive's Data Integrator is a great tool, I highly recommend it! We
changed our chart of accounts #'s, terms codes, sales rep codes, customer
codes, supplier codes and many other things during our conversion. I don't
see how we could have smoothly managed that much change in such a short time
period without the Data Integrator.

Good Luck!

Dan Snyder
IT Manager
Mercury Electronics
717-428-0222 ext.224

_____

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Hatcher, John
Sent: Thursday, May 22, 2008 8:36 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re:Pervasive or other data integration tools...

We are nearing our go live date (6/9) and took the route of purchasing
and using the Pervasive tool.

I have gone through about 6 conversions during our implementation and
have found the product to work well.

We opted to purchase the professional edition directly from Pervasive.
What we found is that the version sold by Epicor is less expensive but
also lacks many of the data connectors which would make the tool useful
in the long term.

Our approach involved using the test database as a baseline for each
import. The baseline includes released customizations, import of
non-changing data, company setup, etc. We then copy the test to pilot
and perform the reimport to pilot. A tightly controlled access
procedure to the test database has been necessary and a careful
regulated development process to ensure that customizations, BAQ's, etc.
make it into the test database once test and approved.

I have had to develop a four page procedure to follow during the import
process to ensure all steps are completed correctly, data cleansing is
done, post updates are run, etc. I found that while the maps and
templates work well there is no help for understanding the sequence that
is necessary and various and sundry quirks and extra imports/updates
that were necessary to really get the system functional. I'm very happy
that we went this route because we would never have gotten as much data
across and the system functionality to the point we have by getting a
standard conversion done.

You're welcome to contact me directly if you would like to discuss
further.

John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)

.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msgId=6
5148/stime=1211459779/nc1=4507179/nc2=3848644/nc3=5191954>


[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Here is the list price that we were quoted in November 2007.

Data Integrator Professional:

Design Studio
$3,950

Engine (Windows)
$8,950



Data Integrator Universal:

Design Studio
$5,950

Engine (Windows)
$14,950


We purchased the Universal Design Studio. The Design Studio is a developer
license that allows 1 person to develop and manually execute conversion
programs. If you want to setup automated conversions on a server to run
daily ETL's or real-time EDI or Web Services processing you need the
"Engine". Since our initial conversions were one time conversions, we did
not need the Engine. We purchased the "Universal" version since it has EDI,
Web Services and data joining/merging capabilities. We are hoping that we
can use the Data Integrator in the future instead of Service Connect ($20K)
and other third party EDI processing tools ($10K).

From Pervasive you get something like 200+ input/output adaptors to
different databases and applications. My understanding is that if purchased
from Epicor you only get a Text input to an ODBC database output (progress
or SQL). I believe Epicor does give you the "Engine", but it didn't seem
that useful without the other adaptors and we needed the join capabilities.

Dan Snyder
IT Manager
Mercury Electronics
717-428-0222 ext.224



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rojas, Joe
Sent: Thursday, May 22, 2008 9:24 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re:Pervasive or other data integration tools...



How much did Data Integrator cost when purchased directly from
Pervasive?

Joe Rojas

Information Technology Manager

Symmetry Medical New Bedford

P: 508.998.4575

C:508.838.4717

F:508.995.9597

joe.rojas@symmetryn <mailto:joe.rojas%40symmetrynb.com> b.com
<mailto:joe.rojas@symmetryn <mailto:joe.rojas%40symmetrynb.com> b.com>


.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msgId=6
5152/stime=1211462647/nc1=4507179/nc2=3848642/nc3=4990217>



[Non-text portions of this message have been removed]