Skip to main content

Data Integration with Context

Written by: Mark Cowan, CDO, Put It Forward

17 January 2019.

7 minutes read

Data integration is no longer about connecting one system or application to another. It’s about connecting people, systems and data to enable unrestricted collaboration and cohesive data stories. One story is your customer lifecycle. The right approach to data integration makes your customer lifecycle visible and actionable from the first contact through every touch point, so employees involved along the way have the information they need to do their jobs.

What is the right integration approach? We operate in a world of choices, and one in which we are trying to create platforms on which to operate our businesses. In a platform view, disjointed products need to work together. The integration method you choose determines how well the products connect and transfer data and the degree to which you can control your data and data quality, transparency, measurability, usability and security ― and ultimately your data stories.

Ideally, data integration is comparable to snapping together a toy’s colored plastic squares. The pieces all fit, and each piece connects with others to form one cohesive unit.

Integration Types:  True Effects on the Business

Purchasing trends are shifting from IT to line of business (LOB) buyers who are trying to solve a problem quickly ― improving collaboration or generating revenue, for example. The enterprise data strategy and integration approach most likely aren’t decision factors, but they should be.

Integration approaches fall into two categories: code-based and configuration-based.

Code-Based Integration

Code-based integration is point-to-point integration, like a string fixed between soup cans. Point-to-point integration allows simple data transfer in one direction with field-to-field mapping. Users can’t validate or correct data because they have no visibility into the data flow. Point-to-point integration, which is not recommended to connect more than three points, is supplied in these forms:

  • Native integration ― branded or “skinned” by vendors that deliver it with their products. Leads to platform brittleness because swapping out anything is difficult.
  • Vendor-embedded ― vendor-licensed third-party code embedded inside a product.
  • Developer-supplied ― costly custom code that involves many enterprise resources and takes weeks or months to move through development, testing and quality assurance before it goes into production.

The outcome of code-based approaches? Multiple, parallel, opaque, inflexible integrations that hide and restrict data flow. While a vendor-supplied native integration is “free,” it doesn’t provide control. And costs can add up quickly when you consider code fixes, decisions based on bad data, and missed opportunities resulting from lack of analytics.

Third-Party Configuration-Based Integration

A third-party configuration-based integrator takes ownership of applications, code, and maintenance, relieving enterprises of the burden of deployment and management. Put It Forward’s data automation network integrates data services, development, and management tools, offering a “flip the switch” approach that allows business rules, properties, and schedules, all in one platform. Using preconfigured templates, users can connect applications in a few minutes, enabling bi-directional data transfer and even on-the-fly changes. All with no data throttling, memory allotments or scalability limits.

This approach easily solves LOB problems, and it shifts the conversation from technical integration to business integration. IT can manage at the platform level and better orchestrate where data is going or where it needs to go. Instead of writing code, developers can focus on strategic business issues.

Configuration-based integration puts enterprises on the path to:

  • Platform independence
  • Application independence
  • Control of data stories
  • Lower overall platform cost

Outcomes of configuration-based integration:

  • Reduce lead qualification time by up to 175%
  • Increase productivity by 10-20x
  • Increase customer satisfaction by up to 6x

At Put It Forward, we believe that an enterprise can operate best when information is put forward to the next person in line whose job is dependent on good data. A configuration approach includes a prebuilt foundation unto which business rules, APIs, analytics, and products can be layered.

The solution provides transparency, measurability, usability, accuracy, completeness, repairability and security. It checks data integrity; for example, two fields go through integration and need to equal three. Logs and time stamps record activities. Views are customizable for each user and for managers and administrators.

About the Author: Mark Cowan is the Chief Data Officer at Put it Forward, the Data Automation Network. He has contributed to the definition of several global data standards, patents for data management, distributed system integration and financial systems. Mark is a recognized expert in system design, integration, and business enablement.

Why IT Organizations Invest in AI Automation Written on 21 February 2023. The last few years have seen an exponential increase in practical use cases of artificial intelligence....

Continue reading

What Is Intelligent Automation And How To Make It Work Intelligent automation automates non-routine processes and tasks that require some level of thought. Businesses that have embraced...

Continue reading

What is Predictive Analytics: Benefits, Types and Tools Made Easy  Executive Summary Predictive analytics uncover and unlock meaning within an organization’s data and turn...

Continue reading

What Is Data Integration? In our modern age, few things are as valuable as access to the right data at the right time. Data access and integration have given rise to several...

Continue reading

What Is a Data Platform? In an enterprise, seeing and storing data is not enough; understanding it is the key to extracting insights that can increase business value. A data...

Continue reading

Vendor Roadmaps:  What You Need To Know Written by:  Mark Cowan, CDO, Put It Forward 22 January 2019. The more information you can get about vendor intentions,...

Continue reading

Put It Forward’s Top Strategic Data Technology and Market Trends for 2021 Put It Forward’s Top Strategic Data Technology and Market Trends for 2021 Cross cloud...

Continue reading

Top Digital Transformation Trends in 2024 Written on December 12, 2023. Learn how organizations manage digital transformation, what challenges they encounter and what are the main...

Continue reading

7 Reasons Why Organizations Need an Integration Solution 38% of businesses struggle with manual data coding, and 32% have issues with connecting multiple data sources. Data...

Continue reading

10 Tips on Improving Your Big Data Analytics Are you looking to improve the amount and the reliability of your big data analytics outcome? Are you unsure of what aspects you...

Continue reading

5 Keys to Successful Data Governance in Snowflake Over 4,000 organizations have adopted Snowflake's data cloud. It's a safe, easy place to externally place business...

Continue reading

Drinking Your Own Champagne - Scaling by Automation and Smart AI Insights How to Punch Above Your Weight and Still Be Cool It’s been said that success leaves clues.  Often...

Continue reading

Risks and Benefits of Robotic Process Automation (RPA) Written August 13, 2021 Today’s business environment tends to go through rapid and often elusive transformations like...

Continue reading

Real-Time Data Integration Best Practices and Architecture Real-time data integration is increasingly becoming the new gold standard in data integration. It immediately processes...

Continue reading

Process Automation vs. Orchestration: What's the Difference? With the increasing workloads, a successful business requires more automated processes with lower human involvement....

Continue reading

Key Differences Between Predictive Analytics and Data Mining In the last decade, big data has become the lifeblood of business organizations across the globe. Predictive analytics...

Continue reading

Intelligent Automation vs. RPA – How Do They Differ? RPA leverages software bots that mimic human activity in completing repetitive tasks like filling in digital forms, creating...

Continue reading

IT Guide: How to THRIVE in 2019 Written by:  Mark Cowan, CDO, Put It Forward 23 January 2019. We work with IT teams every day and have seen that 2019 is...

Continue reading

How Put It Forward Helps to Integrate Sitecore XM Across the Enterprise Put It Forward Sitecore XM™ connectors help deliver great integrated customer experiences across channels...

Continue reading

How to Drive Actionable Insights at Scale With Intelligent Automation Written on April 17, 2024. Discover how intelligent automation can improve your business operations and...

Continue reading

How Generative AI Powers up Process Automation Written on February 9, 2024. Learn how to leverage generative AI to improve the efficiency of your business processes and automate...

Continue reading

What is API Integration as Part of Digital Transformation Written on May 5, 2021 The digital transformation is rapidly gaining momentum in today’s world. And companies are increasingly...

Continue reading

How Householding Customer Data Unlocks Personalization At Scale Problem: Generalized messaging across customer groups where no obvious linkages exist is...

Continue reading

Everything You Need to Know About Snowflake Data Integration Snowflake's data cloud solution has already been adopted by over 4,000 organizations. It's one of the best data...

Continue reading

Evaluate Your Automation Maturity to Drive Business Transformation Written on October 2, 2023. Learn how to evaluate your organization's automation maturity and drive positive...

Continue reading

Enterprise Process Automation and Orchestration Written on May 13, 2024. Unlock the potential of seamless cross-platform automation and orchestration as we delve into...

Continue reading

Data Integration with Context Written by: Mark Cowan, CDO, Put It Forward 17 January 2019. Data integration is no longer about connecting one system...

Continue reading

A Conversation With ChatGPT About Intelligent Automation Written on 06 January 2023. There's much talk and interest about ChatGTP so a conversation was had with it about it's...

Continue reading

Centralized AI - The Mind in the Middle Written by: Mark Cowan - CEO, Put It Forward May 30, 2019 Do little bits of smart make a lot of smart?  Leveraging...

Continue reading

Artificial Intelligence vs. Intelligent Automation. What's the Difference? Around the world, forward-looking organizations are embracing artificial intelligence (AI), among...

Continue reading

AI For Predictive Analytics: Actionable Future Insights AI is everywhere in the modern world, from 77% of the connected devices we use every day to approximately 15% of enterprises that...

Continue reading

7 Steps to AI Closed Loop Marketing - Infographic Sometimes the best blog entry is an infographic, more pictures - less words is a good thing right?  We've broken...

Continue reading

6 Ways Marketers Can Use Machine Learning 6 Ways Marketers Can Use Machine Learning in 2019 We already know that artificial intelligence and machine learning technology will...

Continue reading