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

Posted on 2009-12-30
Last Modified: 2012-05-08
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?
Question by:TCLRazor
    LVL 42

    Expert Comment

    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.
    LVL 42

    Accepted Solution

    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.

    Author Closing Comment

    This provides a workaround rather than the answer I had hoped for.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    SharePoint and OneDrive 1 54
    SharePoint IF/AND statement 4 23
    SharePoint 2013 for Task Tracking 5 40
    CMAL Query - Jsom 1 16
    There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now