Does anyone know of a connector to link Sage Accounts and MOSS 2007 using the buisness data catalog?

I am lloking to add Sage Accounts to the Business Data Catalog for a Microsoft Office SharePoint Server 2007 application. Does anyone know of a connector , or has anyone written the necessary xmlfor this?
TCLRazorAsked:
Who is Participating?
 
zephyr_hex (Megan)Connect With a Mentor DeveloperCommented:
to further my last statement..

i use Sage MAS 90, which is based on ProvideX (i.e.  not SQL)
to link data to sharepoint, i import data from MAS 90 to SQL via SQL Linked Server.
MAS 90 / ProvideX is too slow to handle live data queries, so that's why i import.  you may be able to use direct queries if Sage Accounts database can handle it.

so, i import the tables from MAS 90 to SQL, and then i'm able to use all kinds of options to show data in sharepoint, like Data View Web Part, or BDC.
0
 
zephyr_hex (Megan)DeveloperCommented:
what type of database is used for Sage Accounts?

i'm not aware of a connector, but if it's a standard database, like SQL, then a special connector isn't needed.
0
 
TCLRazorAuthor Commented:
This provides a workaround rather than the answer I had hoped for.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.