<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Category: Products

18 Results

Highlights of Pragmatic Works Product Update 2016.4

Posted Nov 02, 2016 by Devon Stiles

Our team is always striving to improve and innovate our entire suite of products. In our Fall 2016 release, LegiTest, LegiTest Server, Task Factory, DOC xPress, BI xPress and BI xPress Server have notable updates to help improve your data solutions. Here are some highlights of the new features and enhancements in our suite of tools:

Task Factory Transforms SSIS to a True Data Warehouse Solution for the University of Calgary

Posted Sep 13, 2016 by Ryan Dowd

Over the years, our customers have come to know Pragmatic Works as true experts in developing uniquely powerful ETL solutions through Microsoft SQL Server Integration Services (SSIS). Our industry experts have worked in countless customer environments, each with their own challenging data integration needs. Our consultants, who are NOT shy :), often tell us about their experiences and their long wish lists: "If only I could validate that a text file contained the expected information in the expected format before it completes" or "Man, I wish there was a way to conditionally update or insert data faster than I can today."

Developers: Simplify Your Job with BI xPress

Posted Aug 23, 2016 by Pragmatic Works

As a developer, do you often find yourself frustrated with tasks that should be easier to complete? There are many different aspects of the developer role that can be tedious and drawn out. That's why we created BI xPress to simplify your experience when working inside SSDT. Let’s take a look at some common practices in a BI environment and how BI xPress makes those practices easier and smoother to implement.

Highlights of Pragmatic Works Software Update 2016.3

Posted Aug 11, 2016 by Devon Stiles

In our recent webinar, Brian Knight, John Welch and the Pragmatic Works Software Team announced the newest releases of Task Factory, BI xPress and LegiTest. Here's a recap of some of the new features and enhancements in our suite of tools that can help you improve your data solutions.

Exciting Features of SQL Server 2016

Posted May 12, 2016 by John Welch

The new SQL Server 2016 release is just around the corner (June 1st) and we’re really looking forward to it at Pragmatic Works! It’s also a busy time for the Software team, as we have to make sure all of our products play well with the new SQL Server 2016 features. We have just released the 2016.2 build of all of our products, which is compatible with SQL Server 2016 RC3 and will also work with the 2016 RTM release when it is available.

Task Factory Oracle Upsert Destination - Troubleshooting Made Easy

Posted Apr 15, 2016 by Ken Wood

In my first post on Task Factory's Oracle Upsert Destination, I gave you an in-depth "How To" demonstration. In this blog, I'm going to discuss some troubleshooting tips when you encounter errors.

If you’re an avid user of an Oracle Database, you are no stranger to the oddities that are presented when dealing with Oracle Errors.  If this is you, then you may very well be familiar with the following scenario. 

Task Factory Oracle Upsert Destination…A “How to” Demonstration

Posted Apr 07, 2016 by Ken Wood

The Oracle Database presents a challenge to its users, that once mastered, can be rewarding and make the utilization of Oracle specific tools easier to grasp. If you are an avid Oracle user, you are familiar with the many aspects to Oracle that are vastly different than the standard SQL Server language many of us have grown to appreciate

Checking for SSIS File Usage with Task Factory's File Properties Task

Posted Mar 30, 2016 by Shawn Harrison

Have you ever had an SSIS package fail because a source file it reads from was opened somewhere else? This can be especially frustrating if the package in question runs after hours or on weekends. In this post, I'll demonstrate how to avoid this issue with the Task Factory File Properties Task, the Task Factory Timer Task and a For Loop container.

Send Emails in SSIS Using Task Factory's Advanced Email and SMS Task

Posted Mar 16, 2016 by Ken Wood

The Advanced Email and SMS Task from Task Factory is more than just a tool used to send Emails and SMS Text Messages with SSIS. As the name suggests, it’s “Advanced”; of course we can do more with the Advanced Email and SMS Task

Using Task Factory’s REST API Source to Connect to Zendesk

Posted Mar 08, 2016 by Manuel Quintana

Greetings everyone! Today we are going to create an SSIS package using the REST API Source component from Task Factory. Specifically, we are going to use this source component to connect to Zendesk’s API service. When using the REST API Source to connect to any service you must be knowledgeable on how that particular API and what are valid API endpoints.

Subscribe to Blog Updates