Blog on Power BI, Power Apps, Azure, SQL Server, BI, and more!

Connecting to Unusual Data Sources in SSIS

Written by Pragmatic Works | Jun 15, 2017

Many of us think of databases as our main source of data. But there are so many other data sources out there. Different teams within your business use different systems that hold unique data that they need for reports and decisions for their team. Pragmatic Works’ Task Factory product can help all your teams easily get the data they need.

The sales team often uses cloud based customer relationship management (CRM) systems like Dynamics CRM or Salesforce.com. Task Factory has built-in components to pull data out of these CRMs, using SSIS, and into the hands of your sales team to utilize for their day to day decisions.

The accounting team typically uses systems like Quickbooks online or Dynamics GP. Task Factory’s REST Source component will quickly and easily pull the data the accounting team needs. REST Source pulls data from any RESTful web source.

Marketing often needs to make use of data from a wide range of sources like Twitter, Facebook, HubSpot and Google Analytics, to name a few. REST Source can connect to all of these sources and can easily be set up to pull the data into one centralized place. This data can then be used to create dashboards and reports with all your data tied together, instead of in separate siloed systems and reports.

Your business runs on data and each team in your organization needs their data to make effective decisions. Getting the data you need can be a time-consuming task, but Pragmatic Works’ Task Factory makes pulling data quick, easy and efficient. The REST Source Component allows teams to get exactly the data they need from all RESTful data sources. Best of all, Task Factory is forever free in Visual Studio. Check out our website or click the link below to learn more.

Try Task Factory for Free