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.
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.
I am a sales professional - not a formally educated data professional. (I swear!!)
With that being said, my primary focus, here at Pragmatic Works, is to assist my team in generating top-line revenue. In my role, I need to make critical decisions that ensures our sales organization is set up for success – and, ideally, these decisions are supported by data. Fortunately, Pragmatic Works specializes in helping organizations leverage their data to make more informed, intelligent business decisions. To my benefit, I have access to some amazing training resources (the Pragmatic Works Power BI Desktop and Dashboards On-Demand class taught me everything I needed to get started) and talented B.I. professionals that work with data for a living. A virtual thank you to Devin Knight and the Pragmatic Works Virtual Mentoring Team for being available to help me work through this small project!
Hello Dear Reader! Recently we hosted a webinar for Pragmatic Works, Mission Critical Applications SQL Server and Superdome X. The brilliant engineers over at HP invited Pragmatic Works to be the premier partner working with them to execute proof of concept (POC) engagements for clients. This has allowed us to take a close look at the hardware and see where it can really help people.
In my previous blog, we discussed some of the problems you may be facing that's causing your training efforts to fail. Now you're probably wondering what the solutions to those problems are. If society being easily distracted is the core problem for keeping people engaged, then what’s the solution? What is needed to have attendees leave a training class feeling excited about what they just learned? How can you make students leave feeling like they can actually use what they learned to solve real world problems?
Let's take a look at ways you can make sure your training endeavors are successful.
Attending a training class should be an exciting experience. You’re learning something new and hopefully something you can actually use. You’re sitting in a room full of people that likely are struggling with the same problems you are and have what should be an expert teaching you how to solve those problems. However, we often find ourselves distracted, bored or even put to sleep.