Andrew Holowaty, Author at Perficient Blogs
Blog

Posts by this Author

  • Topics
  • Industries
  • Partners

Explore

Topics

Industries

Partners

Andrew Holowaty

Posts by this author:

Advanced Data Integration with SSIS, Part 3

This is part three in a series of extending SSIS for the enterprise with complementary Microsoft products. Different industries have standards for data such as Accord for insurance, HL7 for medical, and Eagle-PACE for finance. These standards have a defined data model that can also be used for data exchange. One of the transports for […]

Read more

Advanced Data Integration with SSIS, Part 2

This is part two in a series of extending SSIS for the enterprise with complementary Microsoft products. Specifically, we are going to look at how we can extend an SSIS solution to go through DMZs and firewalls across the Internet to reach and capture data regardless of the SQL Server schema type. In this scenario, […]

Read more

Advanced Data Integration with SSIS

Over the past few years, I have had the privilege of working with some of the world’s largest companies in a variety of industries. One thing in common with all of these engagements was using SQL Server Integration Services (SSIS) as the tool of migrating data for the companies’ business intelligence collateral. I have developed […]

Read more

The Dependency Checker Accelerator

The database centric solutions created by the National Microsoft Business Intelligence Practice often require a sequence of events that must run in a certain order. An example of a sequence of events is loading a data warehouse and there are multiple jobs to do the load that need to occur in a certain order. Often […]

Read more

ETL better and faster

Having been in consulting for over 18 years, I am often asked by business owners or senior management how they can deliver solutions that are faster and better. They also want world-class products that captivate the customer, in addition to better predictability in the solutions delivered. I have found a way to have repeatable success […]

Read more

Doing ETL right…

Have you ever been responsible for ETL and your end user(s) report that the numbers are not right?  Do you have a methodology or a process to go back and verify the numbers are what they are?  When you are building ETL, are you writing audits logs that capture metrics that are important to the […]

Read more

Subscribe to the Weekly Blog Digest:

Sign Up