<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

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.

Bulk Deleting Data from SalesForce.com Using SSIS and Task Factory

Posted Feb 25, 2016 by Brian Knight

One of the most frustrating things about SalesForce.com is the feeling of constantly looking over your shoulder to make sure you don't run out of space. Doing bulk deletion of records in SalesForce.com to fix this issue is done 200 rows at a time and takes a lot of time to setup. While there are many tools out there to help with this issue, the tend to cost quite a bit. This blog and video shows you a quick 4 minute solution to remove tons of rows from SalesForce using a free tool in Visual Studio, Task Factory and SSIS.

Using the Task Factory REST Source with GoToWebinar

Posted Feb 25, 2016 by Shawn Harrison

Today, I'm going to show you an easy way to use REST API calls to bring data into SSIS. Task Factory has a new REST Source that enables users to retrieve data from websites using the REST API. It's a rather powerful source component that can be used in a number of ways. I want to focus on general usage and how to split values into separate columns when retrieving data in JSON format.

Performing Joins Within the Salesforce Source from Task Factory

Posted Feb 16, 2016 by Ken Wood

The question has been posed many times, “Is it possible to perform joins with Task Factory’s SalesForce Source component?” The answer is a resounding “YES!” Not only is it possible, but it’s actually very simple.


Blog Comments

Need help with this topic? Ask the author below.

 

Subscribe to Blog Updates