<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

34 Results

Using REST Source to Get Data from Google Analytics

Posted Apr 14, 2017 by Pragmatic Works

We get it, you’ve got tons of data in external sources, such as Google Analytics, and it’s time consuming to dig through to get the data you need to make decisions for your business. Wouldn’t it be great to have the information you need gathered for you in one place?

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.


Blog Comments

Need help with this topic? Ask the author below.

 

Subscribe to Blog Updates