Pulling Data out of Vantage 6.1 to Data Warehouse

We are pulling data from V5.2 (similar to 6.1) via MS SQL 2000. Works
fairly well.



Don







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert MacDonald
Sent: Tuesday, June 06, 2006 9:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Pulling Data out of Vantage 6.1 to Data Warehouse



Hello Group,

We would like to setup a data warehouse, pulling data from many sources,
including Vantage 6.1. Currently we have had great success with MS
Access getting data out of Vantage, but MS Access is not our choice for
a data warehouse. We have been evaluating database products, i.e. MySQL
and MS SQL Server, but the problem is that MySQL has no automated way to
pull the data, and SQL Server 2005 no longer supports older ODBC drivers
(Progress).

Has anyone successful pulled data from Vantage into a data warehouse
type product like the ones mentioned above?

And if so, how did you do it?

Thanks in advance.

Robert MacDonald

Information Technology Manager

Ground Effects Ltd.

Email: rmacdonald@... <mailto:rmacdonald%40gfxltd.com>

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





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

We would like to setup a data warehouse, pulling data from many sources,
including Vantage 6.1. Currently we have had great success with MS
Access getting data out of Vantage, but MS Access is not our choice for
a data warehouse. We have been evaluating database products, i.e. MySQL
and MS SQL Server, but the problem is that MySQL has no automated way to
pull the data, and SQL Server 2005 no longer supports older ODBC drivers
(Progress).

Has anyone successful pulled data from Vantage into a data warehouse
type product like the ones mentioned above?

And if so, how did you do it?



Thanks in advance.



Robert MacDonald

Information Technology Manager

Ground Effects Ltd.

Email: rmacdonald@...





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