All solutions in the Sage accounting variety have the capacity to consider into and out of the accounting system, which creates integration quite workable. At the entry degree there is Sage Immediate and Series 40 that have a proprietary data safe-keeping format but do offer you a computer software developer kit (SDK) and an ODBC driver. The mid selection Sage 2 hundred alternative and the large-end Sage one thousand answer both make use of Microsoft SQL Server (MSSQL) which can facilitate the movement of info in and out delivering you know which tables shop which data! So the possibilities for each and every item are;
Sage (Line) sixty
Collection 40 really ships with a examine-only ODBC driver. So you can use this driver to export data from Sage fifty into, for instance, Excel or into a third celebration/bespoke application. This has access to all the tables that Sage sixty uses but there is no guidance in conditions of what info is exactly where, generally the table name does reflect the information that it stores but there is no documentation on the 'data model'.
If you will need to get facts into Line 50 then you can either use a single of the import routines in the item which are very good for static information this sort of as clients and suppliers but a touch constrained with transactional information, this sort of as not being in a position to import product sales and invest in orders. Also the Sage 40 SDK makes it possible for the creating of facts into the database and takes attention of updating the necessary platforms. The actual format of the facts is not recognized for positive but I feel it to be some old btrieve kind file storage program. Making use of the ODBC driver with an SQL query device is ok for simple queries but it shortly struggles with multi-table joins. There is a free of charge tool accessible referred to as Sage fifty Explorer which lets you see the facts in any table.
Sage two hundred (and Sage two hundred Suite which is financials plus CRM)
Sage two hundred employs MSSQL so it is quick to extract information. However there are numerous furniture and it can be battle without the info model. Sage does develop a facts design definition document but this is only obtainable to registered Sage developers. The table names are fairly descriptive of the info they maintain so a great developer could get to what they have to have. Sage propose using the Sage 200 SDK for creating information back which tends to make sense as it requires attention of updating the relevant ledgers and carrying out the double entry postings. You can put information immediately into the platforms (unsupported by Sage and risky unless you really know what you are carrying out).
Sage Series 500/Sage 1000
Sage Series 500/1000 does have an API which is really restricted for receiving information into the method. There is an older program named tetralink which also permits fundamental facts import and there is a 3rd celebration application with templates which permits certain data to be uploaded by means of Excel.
The info design in Sage 1000 is enormous and the legacy of the facts design is that it employed to be an old btrieve flat document method and currently even even though it resides inside MSSQL there is no referential integrity, main or foreign keys defined in the information. Add to that there are 1800+ furniture all 8-10 characters in length (hardly descriptive!) and no documentation.
![[Valid RSS feed]](http://www.articlesfree.co.uk/images/icon_Rss.png "Free Articles RSS Feed"){kind=icon}
Category Rss Feed
Print This Article
Add To Favorites
![[Valid RSS feed]](http://www.articlesfree.co.uk/images/rss.jpg "Free Articles RSS Feed")