Entries by John Shantz

Custom Applications and Solutions

Because we are experts with processing data, many clients request customized web applications to provide access and functionality from data they already have or want to collect.  We employee specialists in the development of custom web-based and handheld applications to meet just about any business need you have.  Our focus is primarily on applications that […]

Consultant Advises CMU Students on Cutting Edge Capstone Project

Data Warehouse Consultants is focused on the Western Pennsylvania market and encourages our consultants to support the local institutions here.  Bob Brichacek,  a senior consultant for the firm, moonlights as an adjunct professor at the Carnegie Mellon University Heinz Graduate School.  Bob teaches a graduate course in Data Warehousing and acts as a regular sponsor of […]

Software Engineer

  DWC is currently seeking to fill a software engineer position. The position requires a strong leader who is comfortable working directly with the client throughout all of a system’s development in a technical environment. Applicants must have previous consulting experience.  This is an excellent position for a consultant at a large consulting services provider […]

Excel External Content Blocked

We have been encountering a new issue with Microsoft Excel and one of our clients had it today.  It took a little while to figure out, so we want to help out others in this situation.   Issue – Excel External/Web Content is Blocked: In most of our interactive applications, we allow for exporting data (either to […]

UPMC Wins Davies Award for Custom DWC Solution

Pittsburgh, PA:  The Children’s Hospital of Pittsburgh of UPMC this week was named the 2015 HIMSS Enterprise Davies Award recipient for two innovative solutions designed and implemented by Data Warehouse Consultants. The Davies Awards program promotes electronic health record-enabled improvement in patient outcomes through sharing of case studies and lessons learned across a wide range […]

Children’s Hospital Implements Radiology Tracking Board

Pittsburgh, PA:  The radiology department at Children’s Hospital of Pittsburgh of UPMC this week began using a customized on-line patient tracking board created for them by Data Warehouse Consultants. This new application significantly reduces the phone calls and coordination that nurses, physicians and staff must do to efficiently move patients through the radiology department. The […]

Development in Sqoop 1 vs Sqoop 2

I was working on a project last week to load data into a HDFS-based Hive database. This was essentially a periodic load so Sqoop appeared to be the best tool for the job. My small project consisted of the following goals: – Connect Sqoop to SQL Server and/or Oracle instances – Export a set of […]