Author Archive for: mditty

The headaches of hosted data

30 Sep
September 30, 2012

Many companies use vendor bought solutions for their CRM and ERP systems. There are many benefits to this, especially if you do not have a large IT staff in house to develop and support it. Findaway fits this scenario, and it works for us very well to meet our business needs. However, it is my job to keep all our data in that hosted cloud environment synced with our local SQL Server environment. In my 3 years here, this has proved to be very challenging a lot of times, and needless to say quite time consuming. I am a SQL dude by trade, which I am awesome at by the way, but I spend a good amount of my time tracking down issues between the 2 environments, as it’s not real time syncing.

Read more →

My SSIS success story

03 Aug
August 3, 2012

Recently I was given a very cool project, cool in the fact that it wasn’t reporting for a change. Our distributor for Catalist Digital Retail, B&T, needed us to build an automated data flow process that will provide them excel and text files on a daily basis of our content. We need to make sure that all of the content updates we receive from publishers makes it to B&T within the day.  Being a SQL dude, I immediately thought of SSIS, which stands for SQL Server Integration Services. SSIS is SQL Server’s toolset for ETL, which stands for Extract, Transform and Load. Using this toolset, I can pull the data from our database into whatever format I need.  All of our company data is initially hosted in a cloud ERP called Netsuite, and we use a product called Boomi to pull that data into our local SQL environment to do reporting and manipulations like this. But that whole ball of oil is for another day.

Read more →

© Copyright 2017 Findaway. All rights reserved.