Excuse my ignorance, I understand the concept of a dts (MS Sql 2005
changes this), how is the sql database created. Is there a way to
"clone" the Progress data structure to a sql db? Can I use the one
Epicor provides ? Do you have any good ideas where I can learn more on
this? The idea of updating a MS Sql database daily and having it able to
connect into Sharepoint is very attractive.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Steve Wirch
Sent: Friday, May 20, 2005 11:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] MS SQL - Progress Replication
Hi,
I create a sql dts service. You can alternatively create a named
server, or use openrowset or other distributed queries. If a table
extract takes more than 20-30 seconds I only select the fields I
actually use. If you aren't using the Characterxx fields taking these
out dramatically improves performance.
Take care,
Steve
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Keith Mailloux
Sent: Friday, May 20, 2005 11:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] MS SQL - Progress Replication
How are you doing your extracts, I can deal with 4 minutes :-). I do
have SQL server running but do not want to run Vantage on SQL.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Steve Wirch
Sent: Friday, May 20, 2005 8:44 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] MS SQL - Progress Replication
Hi Keith,
What you are describing is sql functionality, so I'm guessing you would
need to run Vantage on sql, and then you'd be able to do this.
We're doing massive extracts from vantage into sql, and you are correct,
life is very good. The database is way faster, and report writing is a
snap.
We are porting all of the report builder listings, e-mails, document
prints (who really likes crystal anyways?), and a new
sales/bookings/operations dashboard over to the sql system.
The Vantage server is much faster since we have split the load to the
sql box, and the users are happier because they get their new reports in
minutes instead of weeks. If a user wants a new listing it is normally
just a new sql view instead of a tedious bam, report builder session, or
other Neanderthal tool.
We are using a combination of Microsoft office, asp, vbscript, and cold
fusion's report builder as delivery mechanisms.
The only down side is the database replication, which is taking around 4
minutes with a 1.7GByte database.
Take care,
Steve
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Keith Mailloux
Sent: Thursday, May 19, 2005 3:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] MS SQL - Progress Replication
Somewhere a while ago I read or dreamed that there was a way to create a
MS SQL database and have the Progress Vantage database replicate or
synchronize with it. Does this sound familiar to anyone or was this one
of my had to much of work dreams..... I am interested in some
BI/Sharepoint connectivity and MS SQL is easier for me to deal with (at
least at this point). I do have VBI but we are struggling to get it to
work. Support on this product is very thin (waiting 3 weeks on a call so
far).
Keith
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
changes this), how is the sql database created. Is there a way to
"clone" the Progress data structure to a sql db? Can I use the one
Epicor provides ? Do you have any good ideas where I can learn more on
this? The idea of updating a MS Sql database daily and having it able to
connect into Sharepoint is very attractive.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Steve Wirch
Sent: Friday, May 20, 2005 11:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] MS SQL - Progress Replication
Hi,
I create a sql dts service. You can alternatively create a named
server, or use openrowset or other distributed queries. If a table
extract takes more than 20-30 seconds I only select the fields I
actually use. If you aren't using the Characterxx fields taking these
out dramatically improves performance.
Take care,
Steve
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Keith Mailloux
Sent: Friday, May 20, 2005 11:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] MS SQL - Progress Replication
How are you doing your extracts, I can deal with 4 minutes :-). I do
have SQL server running but do not want to run Vantage on SQL.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Steve Wirch
Sent: Friday, May 20, 2005 8:44 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] MS SQL - Progress Replication
Hi Keith,
What you are describing is sql functionality, so I'm guessing you would
need to run Vantage on sql, and then you'd be able to do this.
We're doing massive extracts from vantage into sql, and you are correct,
life is very good. The database is way faster, and report writing is a
snap.
We are porting all of the report builder listings, e-mails, document
prints (who really likes crystal anyways?), and a new
sales/bookings/operations dashboard over to the sql system.
The Vantage server is much faster since we have split the load to the
sql box, and the users are happier because they get their new reports in
minutes instead of weeks. If a user wants a new listing it is normally
just a new sql view instead of a tedious bam, report builder session, or
other Neanderthal tool.
We are using a combination of Microsoft office, asp, vbscript, and cold
fusion's report builder as delivery mechanisms.
The only down side is the database replication, which is taking around 4
minutes with a 1.7GByte database.
Take care,
Steve
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Keith Mailloux
Sent: Thursday, May 19, 2005 3:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] MS SQL - Progress Replication
Somewhere a while ago I read or dreamed that there was a way to create a
MS SQL database and have the Progress Vantage database replicate or
synchronize with it. Does this sound familiar to anyone or was this one
of my had to much of work dreams..... I am interested in some
BI/Sharepoint connectivity and MS SQL is easier for me to deal with (at
least at this point). I do have VBI but we are struggling to get it to
work. Support on this product is very thin (waiting 3 weeks on a call so
far).
Keith
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]