First off, do not take this posting personal since it is not really
personal, just a general reccomendation that I would give to anyone, no
matter what the situation, no matter what the education level, no matter
what the experience level.
I would reccomend that you first completely learn as much about Vantage
itself and how it works before you start plunging your way through ODBC
access into the system.
Yes, in some instances ODBC is better, but honestly, that is not an inherant
absolute. More often than not people want to access through ODBC just
because it's what they already know and are familiar with and they would
rather do that instead of learning and completely understanding the program
itself, not because it is truly the best or better way to access the
This is not just a Vantage specific instance, this runs accross almost any
type of system that runs off a database. People want to stick with their own
comfort zones instead of learning and completely understanding the program
and how it was built in the first place.
It is a very slippery slope to be getting into, I am sure intentions are
just to do read only for an excel report.... well sure it starts that way
but it can cascade into complete chaos when people just want to do a little
bit more with ODBC, oh then I can just do this with ODBC instead, and I
would save so much time if I just did that with ODBC and if I am going to do
that with ODBC then I can just do this with ODBC... and on and on and then 3
months down the line during quarter close or 8 months later when year end is
going on, it is realized that all those things done through ODBC caused a
problem and since we did that update over here we didn't throw a trigger
over there and now that's all messed up.
While I don't know specifically what you are doing, I would reccomend
learning more about Vantage before you jump into wanting to use ODBC, more
often than not, most things that people want to do with ODBC are already
done in another form, or the use of a BAQ or Crystal Report will gain the
exact same information.
----- Original Message -----
From: "Bob Schnable" <bschnable@...>
Sent: Wednesday, November 04, 2009 1:30 PM
Subject: [Vantage] Vantage ODBC
> Hello everyone,
> I am very new to Vantage, just having started a new job that involves
> the program immensely. I have very familiar with ODBC, specifically the
> QuickBooks ODBC driver, as well as using that to more efficiently grab
> data in useful ways from the program. Generally, I would use VB.net to
> interact with Excel and the QODBC to get my data, sort it and set it up
> the way I wanted to, etc.
> What I am looking for is the place to start in regards to Vantage. From
> what I've read so far, it comes with built in ODBC drivers, I just
> wanted to figure out what most people do and how they use it, and if I
> could be pointed in the direction of some useful sites as far as queries
> for basic reports goes. Can I use the same system as before, just
> running the queries through Excel and Microsoft Query, or is there a
> better way?
> Any help is greatly appreciated! Thanks!
> I already posted this in a geographic specific forum, so sorry for any
> [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:
> (2) To search through old msg's goto:
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links