Everything is working great. You guys are fantastic. With Mike’s help the other day, I would have had no clue as to how to proceed with trouble shooting. It turns out that the Source table database (from our Pharmacy Software) was still corrupt even after their tech support ran a repair. The problem was 3 asterisks in a date field that prevented the import script executing beyond that set of records. I have to say, I just became familiar with your software starting last Friday night and I am very impressed with how well it performs. I have no database programming experience and thanks to Mike, the manual, and your website, I’ve learned a lot or at least enough to ask some of the right questions when things go haywire. We are planning on upgrading to the newest version, however we want to switch out the current computer to a faster one. Once we complete that and everything is working, we will contact you to discuss how best to complete the upgrade process. Thank you for checking up on us. I really appreciate it!
My experience with dbSoftLab
Im no IT guru - just a small business owner trying to build a website for the first time. Initially i had a need to do a simple XML export of an Access database and upload it to our server. Luckily through Google I found etl-tools.com and saw an overwhelming number of choices that I felt could possibly do the job, but I wasn't 100% sure - so I sent them an email. To my amazement I got a response almost immediately from Mike who pointed me in the right direction, and I ended up purchasing Advanced ETL processsor enterprise edition. After getting underway I found I was a little out of my depth, but Mike logged in remotely and got me started. He has been there for me through the entire design process and has promptly fixed any problems I was having for me or showed me how to to do things that were beyond my capabilities. We have now gone from using this software for a simple XML export to also using it to retrieve orders, split orders into separate files for each supplier, ftp these orders to our suppliers, and write the orders into our POS database automatically. I also now have many general in store uses in my mind for this software. Not only is the software itself amazing with almost unlimited capabilities, I cannot stress enough how amazing the service is that I have received from Mike.
Gametraders Marion Adelaide Area,
Up until the past couple of years our company has been able to address our data conditioning needs using MS Access, MS Excel together with VB scripts when needed. Over the past few years, we’ve also been able to take advantage of several Business Intelligence and Electronic Forms Processing software packages. Unfortunately, they all require extensive use of conditioned data, consistent structure within data warehouses and the ability to access and interact with disparate external data sources. Being in the finance industry, we have always strived to leverage the MS Office suite. The next logical step would be moving to SSIS, SSAS and SSRS which are expensive, would require dedicated IT support, and at our size is not cost effective. Virtually all IT is outsourced at this time and managed remotely. Unfortunately, I’m the only one in our management team that has experience in VB scripting and while IT is one of my responsibilities, it is not my primary role in the company. I figured that by now, there must also be software available to assist in our data manipulation needs. I eventually became aware of extract, transform and load (ETL) software. Over the course of several months, I spent many weekends testing several ETL software packages, all of which happened to be Java-based which would require more studying on my part for any needed scripting. Each had a free version with limited functionality. Pricing on desktop or enterprise versions were competing with SQL Server which I thought was inappropriate given the limited utility of the products. About a month ago, I happened upon ETL-tools’ Advanced ETL Processor. While I have only leveraged a small portion of the software’s capabilities, the results have been remarkable given the limited time I have devoted thus far. Despite having hundreds of built-in Validation and Transformation functions, their support team has already added two and shortly the third enhancement to their built-in functions to accommodate our specific needs. This is an exceptional product with awesome customer focus and support!
Charles O. Hall,
Advanced ETL Processor Pro: Out of top 10 ETL tools I tested, dbSoftwarelab provides the only one that can virtually read and write between any standard file formats and DBs without additional user hand coding. And the best thing is, if something doesn't work as expected, dbSoftwarelab service is right at hand - even by remote session. Furthermore, continuous development takes also care for customer's requirements.
Manager Nürnberg Area,
I can only recomend DB Software lab and there product. Im amaized about theier skills and the service they provide to the costumers. We (at Spica Tech) had a DB problem that the ETL SW could not solve. We contacted ETL (Mike) and within week there was new versions supporting the OLD Paradox DB and solved my problem..with no added cost !! Beat that..So, if you need some DB tool for doing what ever, try out ETL-tools.com.
Anders B. Jensen
Owner of Spica Technology,
Uploading our product catalog information from SQL Server to Postgres using SSIS was taking over 45 minutes. With Advanced ETL Processor we were able to reduce that time to under 3 minutes. We love this software!
Director of Software Development
Wow, you are incredible!! Thanks so much for including the working example. I would have never figured this one out.