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

Category: Task Factory

13 Results

How to Get Your Data from GoToWebinar

Posted Mar 07, 2017 by Pragmatic Works

Let’s face it, having to manually pull data from web services into another database platform is time consuming. Manually pulling data leaves room for error and takes time out of your busy day, which leads to inefficiency. REST Source is a component inside Pragmatic Works' Task Factory Suite which will automate the process of connecting to web services to pull information down into your SQL platform. You don’t have to be concerned with the process of getting the data you need – you can rely on it being all in one place. This lets you spend your time thinking about what you want to do with your data. Isn’t this a much better way to spend your time?

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."

Introducing Task Factory's File Gateway Task

Posted Aug 16, 2016 by Manuel Quintana

Greetings everyone! As you may have seen in our recent summer release blog, there are a lot of features new to our tools. Today, we're going to have a look at another fantastic tool from our Task Factory product - the File Gateway Task!

How to Use the SSIS REST Source with Google Analytics

Posted May 03, 2016 by Chris Rock

Pulling data from Google Analytics into SSIS can be a difficult and time-consuming task.  The REST Source in Task Factory allows users to import data to their data flow using Google's Analytics' Rest API. 

The video below gives you step-by-step instruction on how to use the REST Source in Task Factory to pull data from your Google Analytics account into your SSIS data flow. We show how to use both Version 3 and Version 4 of the Google Analytics API’s.

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.

Incrementally Loading Data from Salesforce

Posted Mar 02, 2016 by Brian Knight

As a business owner and someone who is responsible for sales, reporting in SalesForce.com is challenging to say the least. The reporting is tightly restricted to a few objects and the interface can't create the beautiful reports that those in the data industry are used to seeing. Most importantly, I can't merge the data with my existing data sources like data from accounting, HR or our other internal systems. This is why most people pull data from SalesForce.com into a central reporting database to do more advanced reporting. This blog shows you my method for pulling data into a single repository for further reporting.

Subscribe to Blog Updates