Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 10 of 10 total |
Manipulating data from different sources |
Mon, May 4 2009 2:34 PM | Permanent Link |
Peter H | Hi
I am using 4.26 Client Server for a Business management System for a Client. I do some integration with the Clients accounts system (Sage Line 50), which I read from but dont write to using an ODBC driver supplied by Sage. The Sage ODBC Driver is crushingly slow, it can take 30/60 seconds or more to get a few lines of data. My client is fine with it as it saves them lots of work and time. I also do some reports that take a few minutes, my client is fine with this also as it saves a week of work everytime they press the button. I am pretty much stuck with looping through the SageData, querying DBISAM for relevant data. I would like to have a database do the work. For example, I can open the Sage stuff by linking the tables to an Access Database and presumably do joins against a DBISAM database similarly linked with DBISAM ODBC. Anyone got any better ideas? Thanks Peter |
Tue, May 5 2009 10:33 AM | Permanent Link |
Fernando Dias Team Elevate | Peter,
I also have a customer using SAGE software (but not Line 50) that uses MS SQL Server. My approach have been to use ADO in Delphi, to import data from SAGE applications to DBISAM temporary tables, and then produce the reports they want, combining data from SAGE applications with data from the DBISAM database of my application. What database system is the SAGE 50 app using? -- Fernando Dias [Team Elevate] |
Tue, May 5 2009 6:31 PM | Permanent Link |
Peter H | Hi Fernando
Sage Line 50 uses a Sage database of their own format. It was a clunker 10 years ago and its getting no better!!!! If it was SQLServer it would be a breeze, I would ODBC DBISAM and ODBC SQLServer with Access and front end in Delphi. I've spent all day tossing around ideas and I'm going with running a batch job in the night time - I've spoken to the client and they are ok with it. They presently dual entry and reconciling errors is taking them lots of time. Its actually not as bad as it looks as the client has 11,000 invoices and only issues 2000 a year. The job is nothing really as its only 20/30 a day to run some logic on and post or reject and run a report on the rejects. I'll import all 11,000 into a DBISAM table by looping through them which will take a little time, once thats done a select of the new records that have been added to Sage takes about 3 minutes (running on Windows 2003 server!) Once the Invoices have been posted in Sage they cannot be altered other than by raising Credit Notes so if I import the Credit Notes as well it should work. I'm surprised no-one has written a driver for Sage, lots of people use it. Regards Peter |
Fri, May 15 2009 5:10 AM | Permanent Link |
Peter H | Hi
I have an elegant solution to this problem. I import all the Sage recs I need into DBISAM in the night time and let DBISAM do all the work. I 'Top up' the new recs every day which only amounts to 100 recs and run import routines and reporting on them. It has in fact opened a whole new revenue stream for me because the client likes what I have done so much. DBISAM has been fantastic for me as I bought DBISAM for a specific job in 2005 and the job is still ongoing in 2009! The software I created for my client is 'business critical' - the client could not survive one day without it - a programmers dream. I work for myself and DBISAM has put the food on my table for 4 years with no end in sight! Thanks Tim! |
Fri, May 15 2009 8:21 AM | Permanent Link |
"Rita" | "Peter H" <peter.hodgson@software4biz.co.uk> wrote in message news:F46864CE-EAC4-4864-9943-18F650EC5515@news.elevatesoft.com... > > I work for myself and DBISAM has put the food on my table for 4 years with > no end in sight! > That is cool any dinner invitations ? Rita |
Fri, May 15 2009 11:06 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Peter,
<< DBISAM has been fantastic for me as I bought DBISAM for a specific job in 2005 and the job is still ongoing in 2009! The software I created for my client is 'business critical' - the client could not survive one day without it - a programmers dream. I work for myself and DBISAM has put the food on my table for 4 years with no end in sight! >> Thanks for the kind words. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, May 20 2009 9:31 AM | Permanent Link |
Peter H | "Tim Young [Elevate Software]" wrote:
Thanks for the kind words. -- Tim Young Elevate Software www.elevatesoft.com Tim I am still staggered by DBISAM, I find it very fast and reliable. The reliability is key for me. The app has 25 people logged in at all times. The client wanted to be able to put a client on hold and deal with another client at the same time without closing down the first client. Because the client form opens 10 related datasets (contacts, invoices, alerts etc) and another 10 or so and reference tables there were some difficulties in this. I got around this very simply by using command line options to change the look and feel of the application, so the user knows which version of the program they have open. Each user can open the software with two versions at once (X1 and X2). This has worked great and equates to 50 users logged on with the possibilty of as many as 1000 datasets open. I have no difficulty running the server running on a single core AMD 2800 Athlon on Windows 2003 Server. The server occassionally runs slowly as it also handles a Sage accounts program that I would like to off load. The backplane is running on two cheap 48 port gigabyte switches bought (new) on eBay for $150 each. I off loaded 200gigs of documents onto a FreeNas (cut down Linux BSD) box which is used as a document server for the organisation. Apart from a problem at the start with a release (4.21 I think) I have had no data problems or performance issues of any kind. Thanks Again Tim Regards Peter |
Thu, May 21 2009 3:16 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Peter,
That's a great rundown on your implementation. Did you get our emails a while ago about case studies using our products ? We're always looking for customers that are willing to do a case study or small write-up that we can put on the web site. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, May 21 2009 5:57 PM | Permanent Link |
Peter H | "Tim Young [Elevate Software]" wrote:
Peter, That's a great rundown on your implementation. Did you get our emails a while ago about case studies using our products ? We're always looking for customers that are willing to do a case study or small write-up that we can put on the web site. -- Tim Young Elevate Software www.elevatesoft.com Hi Tim I would be very pleased to do a write up of my project over the last few years. Please eMail me and let me know what sort of thing you are looking for. Best Wishes Peter |
Tue, May 26 2009 1:04 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Peter,
<< I would be very pleased to do a write up of my project over the last few years. Please eMail me and let me know what sort of thing you are looking for. >> I sure will, thanks. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |