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?
Category: Task Factory13 Results
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."
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.
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.
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
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.
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.
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.