Our Recent System Integration Software Projects
Here are some examples of the sorts of work we have done with our customers across a variety of system integration projects where we have output information from a database into a format that another piece of software can read. E.g. Sage Accounts.
Contents - Click to jump to an entry
Data output for other softwareWe find that there are many times when customers need to get sets of data out of their systems in a pre-set format so that they can import them into another piece of software.
One common example of this is Sage accounts. Many of our systems include creating invoices, as these are a natural progression from enquiries and quotes through to jobs through to delivery through to invoicing. The invoices produced use information already contained within the system and so can be created very quickly in our database system, without having to re-enter any data. At the same time, clients use Sage to do their book-keeping and so need to maintain the Sales Ledger in Sage. In this case, we set up a very easy-to-use facility to export the sales ledger information from the Access system so that it can be imported straight into Sage.
Other proprietary systems for which we have produced files include QuickBooks and SAP, as well as websites, freight labelling and processing systems and many others. These files can be text files (.txt), comma-separated files (.csv), Excel files (.xls), fixed width files (.dat) and various others.
In a similar vein, we also often set up routines to receive data files from other software, including websites.Database Features:
- Creates files to the exact layout and format required for another piece of software
- Uses the information already contained in your database system
- Not having to enter data into more than one system
- Being able to use off-the-shelf software for some things, whilst having tailored bespoke software where needed
- Creating an integrated system inexpensively