Michael-
What installation guide is it that you have, that has the
instructions for installing ODBC? I would like to get a copy. Thanks!
What installation guide is it that you have, that has the
instructions for installing ODBC? I would like to get a copy. Thanks!
--- In vantage@yahoogroups.com, "Michael Barry" <mbarry@...> wrote:
>
> Gentlemen,
>
>
>
> Let's not be too quick to buy the corporate line and celebrate the
demise of
> ODBC just yet. There remain several compelling reasons to retain
the direct
> connect to the DB despite Epicor's protests to the contrary. First
is the
> fact that they have a vested interest in users utilizing their XML
export
> capability for reporting - simply put, it requires a Vantage
license to
> operate whereas ODBC does not. Second is the performance issue
with large
> multi-company DB's. We've actually witnessed a canned Vantage
Stock Status
> report generate over a 500MB XML file, take over 30 hours to
complete, and
> bring a quad dual-core server to its knees. An identical rewrite
with an
> ODBC connection on the same server completed in under a minute.
> Additionally, non-trivial queries involving multi-table joins or
complex
> filtering or sub-selects have been demonstrated to return
inconsistent
> and/or inaccurate results.
>
>
>
> Besides, it speaks volumes that while Epicor staff continues to
tell scary
> stories about the death of ODBC in the current version, their
install guide
> devotes an entire section to installing the ODBC drivers and
configuring a
> connection.
>
>
>
> Regards,
>
>
>
> Michael
>
>
>
> Michael Barry
> Aspacia Systems Inc
> 866.566.9600
> 312.803.0730 fax
> <http://www.aspacia.com/> http://www.aspacia.com/
>
> This email, and any attachments thereto, is intended only for use
by the
> addressee(s) named herein and may contain legally privileged and/or
> confidential information. If you are not the intended recipient of
this
> email, you are hereby notified that any dissemination, distribution
or
> copying of this email, and any attachments thereto, is strictly
prohibited.
> If you have received this email in error, please immediately notify
me by
> telephone and permanently delete the original and any copy of any
email and
> any printout thereof.
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Todd Caughey
> Sent: Thursday, February 28, 2008 10:53 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Report Writing in Version 8
>
>
>
> Jasper,
> My take, based on Perspectives presentations, is that whatever BAQs
and
> dashboards don't handle for reporting the creation of XML files
(like 6.x
> DBF files) by your own BAQ routines will feed Crystal. No
limitations to
> provided fields either on the canned Crystal reports as you can add
anything
> from the tables involved and, I think, from other tables as well.
There is
> still ODBC for more or less direct to the DB but several Epicor
people have
> told be ODBC is basically dead for 8.x.
>
> In short reporting will be (is) far more flexible in 8.x. It will
still be a
> PITA for us to convert 500 or so RB reports BUT most of these are
simple
> query or lookup reports that will not require Crystal. Then again
som are
> very very complicated even for RB so the Crystal conversion will be
a
> challenge. In some cases I may use other reporting tools against
export XML
> files and am pondering some SharePoint Services potential for online
> reporting. But first things first...getting 8.x running with our
data. The
> rest will ahve to wait.
>
> -Todd C.
>
> ________________________________
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf Of Jasper Recto
> Sent: Thursday, February 28, 2008 12:04 PM
> To: Vantage Groups (E-mail)
> Subject: [Vantage] Report Writing in Version 8
>
> In version 6, Vantage uses both Crystal reports and report builder
for its
> reporting.
>
> Report builder would connect directly to the database tables to get
its
> information. The crystal reports would have to get its information
from
> tables that are created and stored on the working directory on the
users c:\
> drive.
>
> In version 8, how does it work now without report builder?
>
> Does their built in crystal forms and reports still use tables
generated by
> the application or does it connect directly to the database tables?
>
> The reason I ask is because in version 6, the tables that are
generation
> don't always include ALL fields in the table it uses. If you need
some
> information that was not brought over to the temp table, you out of
luck.
>
> I noticed in the last thread titled 'Crystal Invoices', the user
used ODBC
> in their form to add more data. Can you do this for all their forms?
>
> Thanks,
> Jasper
>
> [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]
>