Power of the Pipes
One of my favorite parts of life here at SnapLogic is observing how customers apply our system to build the integrations that drive their business. We call these data flows “pipelines,” and our customers find some very interesting ways to map and improve their business processes with them. What often starts as a simple specification to connect two systems evolves into something much more valuable as the customer unlocks the power and flexibility of the SnapLogic Designer and platform. Customers quickly realize that data flowing through pipelines can be cleansed, enhanced, aggregated or augmented with other data as it flows from point A to point B. We encourage users to ask themselves questions such as “Where in my organization is data I could pull into this system to allow me to make better decisions?” or “Where else can I push this data to benefit others in the organization?”. And since pipelines are easy to build by dragging, dropping and connecting components, you can easily build, test and modify them to explore these ideas.
I like to say: If you can draw it up on a napkin, you can make it happen with SnapLogic.
Take for example the ability to perform data routing to multiple systems while using tools like a complex filtering component to add value. A user might set up a pipeline to take data from an online order management system and then route that data to Salesforce.com to update an account as well as their project management system to initiate a job.
The company realizes that they could add tremendous value to the system by setting flags against the accounts and jobs to give downstream users important insights into their customers. So the company creates an additional input pipeline from an order history database that pulls in historical sales data. From this, they will be able to set criteria and flag jobs and accounts as “New,” “Existing” or “High Value.”
Component – Read from Source: Order Management system
Component – Read from Source: Order History database
Component – Join: Joins data from our two sources
Component – Complex filter: Groups accounts based on criteria: New, Existing, High Value
Component – Constants: Allows the flags to be added to the data for each account
Component – Write to Target: Salesforce.com CRM
Component – Write to Target: Project Management system
Building on this, the customer may create an additional pipeline which to automatically populate a separate database for the Preferred Account Management group team with accounts that should get “white glove” treatment.
The possibilities are endless.
I’d love to hear examples from our customers about how you have used SnapLogic pipelines to streamline or enhance your business operations.