Vantage - Problem with Parts & Costing ID

Yahoo Archive
21
Hi Vic:

Can you clear up something for me regarding your last paragraph?

I am on Vantage8.03/Progress. If I were to use ODBC, aren't I still
using a Progress license everytime I connect via ODBC? Therefore, a
Vantage license will still, in a sense, used by those people viewing
reports via ODBC, correct?

Lynn

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:
>
> It's risky to *populate* the database circumventing the Vantage biz
logic.
>
> It's *never* risky to VIEW data via circumventing Vantage. It may
be slow or it may be inaccurate, but it's not "risky". I do it all
the time. If you are just viewing data (no modify, insert, update,
etc), there is zero risk. If you choose to go this route, either
make your ODBC drivers read-only OR (as I do with SQL) create SQL
Views on the tables I want to use to avoid locks and strictly keep
the data view-only.
>
> In fact, I've created an entire Vantage Intranet using ASP and SQL
and hit our tables, view reports, etc. I even have created an entire
time tracking system for our 100 engineers to enter time to a UD
table against projects and jobs. Once the time has been verified by
their manager, I have a SQL trigger on UD20 that populates LaborHed
and LaborDtl accordingly and safely. All circumventing Vantage.
Saving lots and lots of money initially and annually.
>
> It's great for Execs and certain scenarios where it's ridiculous to
purchase a license for their level of use. It allows me to not have
to purchase a license for Vantage (and thereby not paying annual
maintenance on them, too) for someone who would use Vantage for 5
mins a day or just wants to see Sales to date or oh-hand
inventory.......
>
>
>
>
> Vic Drecchio
> ERP Administrator
> Â
> TIMCO Aviation Services
> Greensboro, NC
> Email:Â Â vic.drecchio@...
> Office:Â 336.668.4410 x3091
> Mobile:Â 704.530.3092
>
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of nmtaylor1969
> Sent: Tuesday, November 18, 2008 9:55 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
> Charlie,
>
> I am interested in your comments here...
>
> Are you saying that you hit the DB directly without going through
the
> business logic...?
>
> I confess I do this every now and again, but it is risky...!
>
> Isn't it like playing Russian Roulette...!?
>
> Thanks,
>
> Nick
>
> --- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@>
> wrote:
> >
> > This is true..
> >
> >
> >
> > I like the down and dirty VBS.
> >
> >
> >
> > It took me a little while to figure out the ODBC setup for
progress.
> >
> >
> >
> > I use it for a data pull for a piece of reporting software we
use.
> >
> >
> >
> > Set cn = CreateObject("ADODB.Connection")
> >
> >
> >
> > strCS = "Driver=Progress OpenEdge 10.1B
> >
>
driver;HOST=ERPSERVER;DB=mfgsys;UID=sysprogress;PWD=sysprogress;PORT=8
> 350;"
> >
> >
> >
> > cn.open strCS
> >
> >
> >
> > Set rs = CreateObject("ADODB.recordset")
> >
> >
> >
> > strSQL = "Select statement"
> >
> >
> >
> > rs.open strSQL, cn, 3,3
> >
> >
> >
> > Obvious this is for openedge 10.1B it can be changed to work for
> 10.0
> >
> >
> >
> > If you are every going to do anything like this at any point
never
> do it
> > without through testing. If you can I would recommend building a
> totally
> > different server and loading it with a copy of your DB and test
all
> scripts
> > to make sure you get exactly what you want. I would also
recommend
> that you
> > Kick off all users and make a backup of the DB then make your
> changes.
> > Confirm your changes worked the way you wanted and then allow all
> the other
> > users back in. Doing this will allow you to roll back on your
> backup if
> > something goes wrong.
> >
> > _____
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > Mark Wonsil
> > Sent: Tuesday, November 18, 2008 9:32 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Re: Vantage - Problem with Parts & Costing
ID
> >
> >
> >
> > > You can also do this through a VBS script using the ODBC if I
am
> not
> > > mistaken.
> >
> > Or VB.Net through the Business Objects...
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg.com
> > Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date:
> 11/17/2008
> > 5:24 PM
> >
> >
> >
> >
> > [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/.
> (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/linksYahoo! Groups Links
>
22
If you are using a BAQ Crystal Report, you don't need ODBC.



--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...>
wrote:
>
> I think I might let Epicor have a look at this one.
>
> In the meantime I have a Crystal BOM report but I need to ODBC from
Crystal to Vantage to view the data.
>
> Any ideas?
>
>
>
>
> ________________________________
> From: Charlie Wilson <foamdesigncsw@...>
> To: vantage@...
> Sent: Tuesday, November 18, 2008 2:43:29 PM
> Subject: RE: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
> This is true..
>
> I like the down and dirty VBS.
>
> It took me a little while to figure out the ODBC setup for progress.
>
> I use it for a data pull for a piece of reporting software we use.
>
> Set cn = CreateObject( "ADODB.Connectio n")
>
> strCS = "Driver=Progress OpenEdge 10.1B
> driver;HOST= ERPSERVER; DB=mfgsys; UID=sysprogress;
PWD=sysprogress; PORT=8350; "
>
> cn.open strCS
>
> Set rs = CreateObject( "ADODB.recordset ")
>
> strSQL = "Select statement"
>
> rs.open strSQL, cn, 3,3
>
> Obvious this is for openedge 10.1B it can be changed to work for
10.0
>
> If you are every going to do anything like this at any point never
do it
> without through testing. If you can I would recommend building a
totally
> different server and loading it with a copy of your DB and test all
scripts
> to make sure you get exactly what you want. I would also recommend
that you
> Kick off all users and make a backup of the DB then make your
changes.
> Confirm your changes worked the way you wanted and then allow all
the other
> users back in. Doing this will allow you to roll back on your
backup if
> something goes wrong.
>
> _____
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf Of
> Mark Wonsil
> Sent: Tuesday, November 18, 2008 9:32 AM
> To: vantage@yahoogroups .com
> Subject: RE: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
> > You can also do this through a VBS script using the ODBC if I am
not
> > mistaken.
>
> Or VB.Net through the Business Objects...
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg com
> Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date:
11/17/2008
> 5:24 PM
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
23
According to my last training class you are correct.



~Charlie



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Lynn
Sent: Tuesday, November 18, 2008 10:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID



Hi Vic:

Can you clear up something for me regarding your last paragraph?

I am on Vantage8.03/Progress. If I were to use ODBC, aren't I still
using a Progress license everytime I connect via ODBC? Therefore, a
Vantage license will still, in a sense, used by those people viewing
reports via ODBC, correct?

Lynn

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Vic
Drecchio" <vic.drecchio@...>
wrote:
>
> It's risky to *populate* the database circumventing the Vantage biz
logic.
>
> It's *never* risky to VIEW data via circumventing Vantage. It may
be slow or it may be inaccurate, but it's not "risky". I do it all
the time. If you are just viewing data (no modify, insert, update,
etc), there is zero risk. If you choose to go this route, either
make your ODBC drivers read-only OR (as I do with SQL) create SQL
Views on the tables I want to use to avoid locks and strictly keep
the data view-only.
>
> In fact, I've created an entire Vantage Intranet using ASP and SQL
and hit our tables, view reports, etc. I even have created an entire
time tracking system for our 100 engineers to enter time to a UD
table against projects and jobs. Once the time has been verified by
their manager, I have a SQL trigger on UD20 that populates LaborHed
and LaborDtl accordingly and safely. All circumventing Vantage.
Saving lots and lots of money initially and annually.
>
> It's great for Execs and certain scenarios where it's ridiculous to
purchase a license for their level of use. It allows me to not have
to purchase a license for Vantage (and thereby not paying annual
maintenance on them, too) for someone who would use Vantage for 5
mins a day or just wants to see Sales to date or oh-hand
inventory.......
>
>
>
>
> Vic Drecchio
> ERP Administrator
>
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@...
> Office: 336.668.4410 x3091
> Mobile: 704.530.3092
>
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of nmtaylor1969
> Sent: Tuesday, November 18, 2008 9:55 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
> Charlie,
>
> I am interested in your comments here...
>
> Are you saying that you hit the DB directly without going through
the
> business logic...?
>
> I confess I do this every now and again, but it is risky...!
>
> Isn't it like playing Russian Roulette...!?
>
> Thanks,
>
> Nick
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"Charlie Wilson" <foamdesigncsw@>
> wrote:
> >
> > This is true..
> >
> >
> >
> > I like the down and dirty VBS.
> >
> >
> >
> > It took me a little while to figure out the ODBC setup for
progress.
> >
> >
> >
> > I use it for a data pull for a piece of reporting software we
use.
> >
> >
> >
> > Set cn = CreateObject("ADODB.Connection")
> >
> >
> >
> > strCS = "Driver=Progress OpenEdge 10.1B
> >
>
driver;HOST=ERPSERVER;DB=mfgsys;UID=sysprogress;PWD=sysprogress;PORT=8
> 350;"
> >
> >
> >
> > cn.open strCS
> >
> >
> >
> > Set rs = CreateObject("ADODB.recordset")
> >
> >
> >
> > strSQL = "Select statement"
> >
> >
> >
> > rs.open strSQL, cn, 3,3
> >
> >
> >
> > Obvious this is for openedge 10.1B it can be changed to work for
> 10.0
> >
> >
> >
> > If you are every going to do anything like this at any point
never
> do it
> > without through testing. If you can I would recommend building a
> totally
> > different server and loading it with a copy of your DB and test
all
> scripts
> > to make sure you get exactly what you want. I would also
recommend
> that you
> > Kick off all users and make a backup of the DB then make your
> changes.
> > Confirm your changes worked the way you wanted and then allow all
> the other
> > users back in. Doing this will allow you to roll back on your
> backup if
> > something goes wrong.
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > Mark Wonsil
> > Sent: Tuesday, November 18, 2008 9:32 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: RE: [Vantage] Re: Vantage - Problem with Parts & Costing
ID
> >
> >
> >
> > > You can also do this through a VBS script using the ODBC if I
am
> not
> > > mistaken.
> >
> > Or VB.Net through the Business Objects...
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg. <http://www.avg.com> com
> > Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date:
> 11/17/2008
> > 5:24 PM
> >
> >
> >
> >
> > [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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
>



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date: 11/17/2008
5:24 PM




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