MAS200


J

j.t.w

I have a couple of other questions...

From my understanding MAS200 runs on a SQL Server database and/or a
ProvideX database. What is the difference?

I've read online that there is an ODBC driver avaliable, but it is
read-only. Is this true? Why?

If MAS200 runs on SQL Server, getting to the data via Enterprise
Manager, Query Analyzer, Crystal Reports, Access, etc. should be
possible. Can someone confirm this?

Thanks,
j.t.w
 
Ad

Advertisements

R

Roy Hobbs

I have a couple of other questions...

From my understanding MAS200 runs on a SQL Server database and/or a
ProvideX database. What is the difference?

I've read online that there is an ODBC driver avaliable, but it is
read-only. Is this true? Why?

If MAS200 runs on SQL Server, getting to the data via Enterprise
Manager, Query Analyzer, Crystal Reports, Access, etc. should be
possible. Can someone confirm this?

Thanks,
j.t.w
Hi JTW,

The Providex is the more "natural" db of the two. The MAS 200 SQL
version uses the ODBC to write to the SQL database, instead of
directly to the Providex flat-file db. Unless SQL is an absolute
"must have" for some reason, there is no real good reason not to go
with the Providex db.

Yes, MAS 200 uses an ODBC driver to connect with any other tool
(crystal, excel, access...) and it is unidirectional - read only. The
bi-directional ODBC used in the SQL version is not accessible by end-
users. Sage Software does not want users to put data directly to the
data files because it circumvents the business logic. For example,
when posting an AR Invoice, as many as a half-dozen data files are
hit, each in a unique way. Only the Sage business logic really knows
which files to hit and with what. Therefore the only way to get data
into MAS 200 is through manual data entry OR the Visual Integrator
Module. The Visual Integrator (VI) module is an import tool with
built in scripts that know how to post imported data to the myriad of
different data files properly. There are no "default" imports in VI
however as so you will need a technicial to build the routines used by
VI and depending on the complexity this is typically at minimum 4
hours of labor.

If using the MAS 200 SQL version, you can get at the MAS data with
Crystal or Excel or Access or anything that uses ODBC. But - you can
do the same thing with the Providex database and it is a lot less
buggy. Unless you MUST HAVE SQL, there isn't an advantage to having
MAS 200 SQL and the SQL version will likely give you many more
headaches.

Cheers.

Roy Hobbs
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top