They gave us our own dedicated server with our own root access. so we can integrate ParaSQL with just about any other system. The way we do that is by utilizing the full programability of their database triggers, stored procedures, custom functions, scheduled events (like cron jobs to run batches, etc)... which makes the back end fully programmable (variables, branching, looping) using ANSI SQL, which is pretty cool.
Mini Q&A with Paul Cowan, CEO of ProPiercing Inc. [posted with permission of interviewee]
ProPiercing is a multi-channel e-commerce retailer of body jewelry, fashion accessories & fine jewelry founded in 2002.
Their database has hundreds of tables and millions of rows of data and is automatically refreshed from external databases several times per day.
What kinds of business problems have you been able to solve with ParaSQL?
"ParaSQL has allowed us to build custom user interfaces to interact with our data in a number of ways, and automate processes that used to be labor intensive and error prone. Examples include a purchasing application to automate inventory restocking, and reporting tools to assess product sales by supplier or product line.
How did you manage the process prior to using ParaSQL?
"Previously our restocking was done via spreadsheets in excel. We had to export sales data from various sources, and manually compile purchase orders. This was very time consuming.
"ParaSQL eliminated all of the labor involved in this process. We are able to generate a Purchase Order by clicking a button in our app. We are able to define rules on when to restock at the SKU level. The result has been fewer errors, less labor, and better results.
What has it been like working with ParaSQL?
"Working with ParaSQL has been a liberating experience. We feel that we have an inexpensive means of building effective, scalable solutions for our business. Unbelievably fast turnaround time and level of commitment to our account. We have been very impressed.
How have you found things like reliability and uptime?
"Perfect. We have had no issues.
Would you recommend ParaSQL to other ecommerce businesses?
"I think ParaSQL is a powerful tool that can be used in many ways by all types of businesses. The possibilities are really endless. If you use excel to do anything manually, ParaSQL will change everything.
Thank you Paul.
ParaSQL has been a huge asset for our company. Our company had been using Google Sheets and Excel to accomplish our reporting. The reporting worked as it should, however sheets wasn't built for heavy sheets linking and querying the data. Which caused constant maintenance on my end to keep everything up and running.
I was given the task of better reporting and knew SQL was the answer but which direction should I go? The answer came while reading a Google Forum which mentioned ParaSQL. They had a risk free trial and after watching their tutorials on their site, I knew this was the answer.
After the trial period I was able to convince our executives we needed this ASAP. We went with the dedicated server route to be able to have the custom functions and control over our server. We have a very odd data set on a daily basis and how we wanted to use ParaSQL was new to them. They embraced our business and every time I had a question or request it was answered quickly. Our requests/questions have not been easy one so it usually required thinking and problem solving on their part.
With ParaSQL your data is easily visible within hours if not minutes. We have been able to operate our business across the country with more pinpoint accuracy on financial decisions since being able to visualize the data and manipulate it quickly.
Wayne Liao, Ph.D.
Director, US Operation
TLC Biopharmaceuticals, Inc.