Data Fabric: What Is It and Why Every Business Needs One

Data Fabric: What Is It and Why Every Business Needs One

What is a Data Fabric? 

…And Why Do You Need One?

Written by Ian C. Tomlin | 12th January 2024

Heard about data fabrics, data lakes and data mesh solutions? Wondering what all the fuss is about? Find out here.

Data access, the innovation imperative

24/7 eCommerce means that every business faces stiff competition from competitors located around the world. Brand experience has become the primary competitive weapon.  It means every business needs to be digital with decisions based on data, not conjecture.  Companies that don’t harness data and modern innovations like artificial intelligence, blockchain, bots, and 3D visualization, etc. face extinction.

 

Why do you need a data fabric?

The organization and exploitation of business data are central to the effectiveness of any business seeking to thrive in the digital era.  Before data can be fully harnessed, it needs to be harvested and blended into a common structural design, where every table and row has its place. This ‘layer’ of composable data is also known as a Data Fabric.  A data fabric is the foundation stone to achieve digital ambitions. It is the key to implementing digital transformation at scale–and specifically to the edge of the enterprise, where it is arguably most needed.

Unbundling data from data silos and disparate data sources

Data is commonly managed and stored by the IT systems that produce it. In a modern IT enterprise architecture, businesses will use a variety of SaaS apps, in addition to Cloud-Native applications, and platforms, like Google, Amazon, Office365, Facebook, LinkedIn, etc.  It means that data is fragmented across data silos, making it all but impossible for business users to access data when they need it.  The rising authority of departmental leaders to make their own IT decisions over the past decade has only served to increase data complexity, adding to the challenges of IT and Data Security leaders charged with protecting and leveraging data.  In most organizations, business systems and data systems are the same thing.

The need to re-think data management

Enterprise data delivery is broken; workers today lack access to the data they need to do their jobs, while executives lack insights to answer what-if questions and make data-driven decisions.  For data engineers, the first problem in any new project is to bring data together from its current source, cleanse, de-dupe, and normalize it, etc. before any serious work can begin to answer new questions, solve problems and build apps.  In most cases, spreadsheets become the only accessible tool to organize data into a useful format. Meanwhile, data governance capabilities remain woefully poor.  This has led to boardroom discussions on digital transformation to pivot towards data access, data sharing, and how to decouple data from the data silos to make it more reusable. Improving data consumption and data quality are now business-critical issues.

Fragmented data architectures slows down the time-to-value delivery of new projects.

Illustration of decoupled data architecture vs current state

Data fabric: what it is and what it looks like 

A data fabric is a conceptual data layer that spans your enterprise, releasing data from the applications and systems where data assets are found, to pre-process and organize it in such a way that it can be made useful for composing reports and be consumed by applications to facilitate machine-to-machine automation. 

A data fabric solution creates a unifying data umbrella layer across your enterprise. It means data is presented in a ready-to-use format. Its main elements include: 

1. Data Integration Tools to connect existing systems that hold data to the data ecosystem. 

2. Extract, Transform and Load Technology to harvest and integrate with data sources, with added tools to design Master Data repositories. 

3. Data Mashup Technology to pluck data from existing data sources into new structures and enrich with new data structures to meet new data demands. 

4. Monitoring, Validation, and Data Integrity Tooling to ensure that data pipelines are working correctly to present data from endpoints while preventing corrupted or high-risk data from being accepted into the data fabric. 

5. Analytical Tooling and Applications Development Software to consume data and present it for different uses. 

A data fabric enables a new standard in data management, presenting data of high integrity that data scientists can use to automate processes and answer questions. 

Encanvas Logo

DIGITAL DOCUMENTS REMASTERED

Micro-Portals • Forms • Reports • Training Dashboards • Charts • Maps • Tables Checklists • Onboarding • Risk Registers • Presentations • eBooks

Data Vault, Data Fabric, Data Lake, or Data Meshwhat’s the difference? 

The terminology used in the data industry can be confusing.  Here we try to unbundle the terms commonly used in data architectural discussions.

Data Vault

You create a Data Vault by designing a data taxonomy around core business intelligence ‘landscapes’ and the core data tables used to describe them.  Typically, these are the core records that identify your customers, suppliers, risks, opportunities, projects, products, etc. This creates a structured model of your critical data assets.  Then, data is normally ‘poured in’ to this by uploading it from its host system and transforming it into a unified single version of the truth.  Data Vaults are typically created using either relational databases or flat-file ‘big data’ systems.

Data Lake

A data lake is a centralized repository built to store, process, and secure large amounts of structured, semi-structured, and unstructured data, storing data in its native format. It is a very specific technological construct that relies on cloud computing and big data technologies to manage vast amounts of aggregated data, organized into a pre-planned taxonomy.  Back in the day, people would talk about data warehouses when thinking about a centralized repository, but cloud computing has changed the narrative.  Whilst Data Lake technology is extremely powerful, it isn’t always practical or affordable. 

Data Fabric

A data fabric is less about an IT platform (as per a data lake) and more about an outcome: it describes the data mart layer used to make data valuable to the enterprise autonomous and composable.  Your data fabric will contain business logic rules that dictate how data is shared, used, managed and consumed.

Data Mesh

A data mesh is more about philosophy and the recognition that businesses have previously seen value in owning data (and thereby trying to control and manage it internally to their business), whereas now, it’s increasingly recognized that harnessing third-party data and sharing it can yield more data asset value.   A data mesh exists therefore within, across, and beyond the enterprise as a federated data ecosystem. 

What are the benefits of a data fabric architecture? 

Strategic ambitions 

A key strategic element of a data fabric architecture is the separation of the data layer from the application layer, fostering greater re-usability of both. Businesses looking to adopt a data fabric approach site one or more of the following objectives. To: 

  • Liberate data from old, inflexible legacy core systems 
  • Transfer the ownership of data from IT to the business 
  • Bring data transparency to create a curious, learn fast/fail fast, data-driven decisioning culture 
  • Speed time to value of new projects and digital services 

Overcoming spreadsheet overload 

Overcoming the risks associated with the use of spreadsheets has become a widescale priority because of data security and privacy compliance. When data is used in spreadsheets, it becomes largely ‘invisible’ to those responsible for data governance.  

Additionally, spreadsheets are costly to produce and manage because of the manpower overheads used to drive them.  

Furthermore, spreadsheet files are prone to corruption and often contain formulas that only the creator understands, creating a single point of failure. 

For all these reasons, industrializing information management by replacing spreadsheets with a robust and resilient data fabric architecture makes sense.

Hyperautomation and digital transformation 

For organizations determined to reduce headcount and drive down back-office costs, removing the human in the loop is a prime driver for data fabrics. 

Becoming data driven 

While the importance of liberating data from data silos, spreadsheets, and increasing the pace of innovation are all good reasons for a data fabric architecture, there’s no question that most organizations will adopt it because it’s the only way for an enterprise to become truly data driven. 

Case stories and examples 

Ask anyone whether they feel well served by data and they will probably have their own horror story of having to use spreadsheets to harvest and manually crunch data to answer a question or solve a problem. Others will be using a spreadsheet as a quasi-business application because their IT team is too busy to find a robust alternative.  

While the ambition to create a data fabric that spans the enterprise is a desirable one, getting to it can be costly. There will always be a need to achieve quick wins along the way. It’s likely that early-stage solutions will be solving problems at a departmental or functional level.  

In this section, we’ve pulled together some examples of how data fabric architectures are being used to solve business problems. Applications for decoupling span the enterprise, although justifications for projects can originate at a departmental level, as illustrated by the examples below. 

Managing growth performance across a sales territory 

The sales division of a global electronics company responsible for the Middle Eastern, Eastern Europe, and African markets was being hampered by a shortfall in sales insights as the result of its widespread data silos. This meant the data-gathering process was time and effort intense.

Managers were presented with copious data but no actionable insights or recommendations for action. To resolve it, a data fabric was created across the regional sales platforms and ERP data repositories that could deliver timely actionable insights to stakeholders on demand. Read the full case story. 

Creating a Customer Data Platform (CDP) to focus operations toward profitable business 

The management team of a progressive Office Equipment and technology business in Europe identified the need to become ‘data driven. The sales leadership wanted to create a single view of its customers to focus sales efforts on the most profitable opportunities and automate delivery processes.  Read the full case story here. 

Scanning the market horizon, and matching resources to opportunities 

Power and Energy is a fast-changing market. In the professional services industry, becoming adept at surfacing new advisory opportunities–also knowing what advisory services to offer and how to resource them–is critical to success. Find out how one global advisory firm used a decoupling architecture to gain a competitive advantage. 

Why codeless PaaS technology is critical to forming a data fabric 

Codeless Platform-as-a-Service (PaaS) solutions take many forms. In the case of Encanvas, its codeless PaaS includes integration and application layers.  

Integration, software bots, and Extract, Transform and Load (ETL) componentry bring data together in a data fabric.  

Then, codeless software is used to design, publish and manage composed applications and machine-to-machine automations. 

Removing the need to program system interfaces, specify information flows using scripts, and write code (or script) to create, publish and manage apps substantially cuts the time and effort needed to implement an effective data fabric and application fabric: the two building blocks of a modern Composable Data Architecture. 

Missing building blocks of enterprise data management 

When organizational priorities for IT are dictated by departmental managers seeking to address operational challenges with point-specific solutions, this inevitably leads to more data silos and a whole series of missing pieces in data architectures. 

One of these is the vital framework of data bridges that link data elements together. It’s not uncommon, for example, to find an enterprise resource planning and customer relationship management solution using different fields to identify a customer. Equally, financial systems may not be correctly configured to identify product or service line profitability. When such data relationships are absent, it’s not possible to ask ‘what-if’ questions that combine multiple data sources, without first bringing data together into a new structure. 

Another missed opportunity is the ability of an enterprise to understand its digital DNA. This is the data that helps an organization define itself, such as the organizational structures, locations, people, processes, suppliers, systems, risks, and data elements that define an organization’s makeup and capability. 

For digital transformation to work you need data fabric architectures 

Businesspeople have been waiting for the day when they could ask what-if questions and access the data they need to do their jobs more efficiently. Businesses want to be data-driven, implement automation at scale, tie front-end and back-end systems together to serve customers better, and bring transparency to data processing. All these ambitions rely on access to useful data.  Consequently, conversations around data services have moved beyond slow-to-build data warehouses and crude point-specific solutions powered by spreadsheets. Enterprise IT has become less about systems and more about data asset value and reuse.   The good news is that codeless PaaS technology makes the implementation of a data fabric affordable as it takes far less time and effort to overcome the issue of data siloes.

Delivering a stand-out customer experience dictates the need for data virtualization

In most digital industries, competitiveness comes down to customer experience.  To achieve simpler customer journeys, more self-service, faster turn-arounds on orders and requests, to adapt faster to market needs, etc., all these outcomes rely on having faster access to more useful data.  Achieving data virtualization by releasing data from systems that hold it to ransom through the formation of a data fabric holds this promise. 

 

Data Lakes are not the answer to every problem 

Whilst the technology is certainly catching the headlines, it would be wrong to assume that harvesting everything into a data lake is a complete or fool proof solution.  There are many wheels to the data fabric wagon and getting data into a single ‘place’ may be a misguided outcome priority for some organizations.  Sometimes, there are quicker wins to be gained by delivering data fabrics across departments and solving a handful of high-priority projects.

Encanvas Logo

DIGITAL DOCUMENTS REMASTERED

Micro-Portals • Forms • Reports • Training Dashboards • Charts • Maps • Tables Checklists • Onboarding • Risk Registers • Presentations • eBooks

Related content

Digital Data Fabric

In this article, find out about our enterprise digital data fabric platform, what it is and why your business needs one.

read more

How Encanvas helped Overall Eesti become data-driven

How Encanvas helped Overall Eesti become data-driven

Data driven businesspeople

The desire of most digital businesses is to make informed decisions driven by rich data analytics. In this article, we explore how digital documents are helping to achieve that.

Business challenges that drive change 

Tonis Haamer is one of the cleverest businesspeople I know. He runs a Overall Eesti, technology business in Estonia along with his brother, Mart. Still today, a big part of the business is office equipment, the company’s heritage. But the market for office printing is not what it was, and this caused Tonis to realize that the onward growth of the business demanded a rethink in how it is resourced.

Now, Overall Eesti is a very people-centric business. The team behind the brand is extremely hard working, extremely loyal. Shedding staff wasn’t a desirable go-forward plan. For this reason, Overall Eesti began its journey to become data driven, and one of the most advanced digital businesses.

What it means to be data driven 

I had the opportunity to interview Tonis on behalf of Canon Europe when I was running strategy around software solutions for the brand. I was looking to see how companies are adopting data insights, and Overall Eesti was an example.

Over a couple days, Tonis explained the objective behind the company’s data driven agenda was to make smarter decisions more often to answer new questions as they emerged, and to reinforce sub-optimal processes with new applications built using digital documents when it became obvious there was an opportunity to streamline.

Tonis explains, “To be data driven means being able to answer new strategic questions as they emerge. To do that means you have to harness your operational data that comes from ERP, service, CRM, HR, and other front-line business systems. It demands the ability to re-use this data for new purposes. And the challenge that brings with it is how to get the quality and integrity right. Once you’ve achieved that, the possibilities open up. But it is not a trivial task to create composable data.”

Data fabric 

Almost a decade ago, Overall Eesti became one of the first companies in the world to create a home-grown Digital Data Fabric they called ‘CLIO.’

As Tonis explains, “Preparing your data is one of the biggest technical challenges of creating a data driven approach to business. It’s not just about harvesting the data you already have. Almost inevitably there will need to be enrichment of data, and you suddenly realize how poor the quality of data is from systems that only use aspects of the databases designed to support their operation. Furthermore, we found that some of the key links between data-sets did not exist. We had to find ways of connecting records in one system with the next by using fuzzy logic matching to construct the relational ties that were missing.”

Data is a big challenge, but it’s not the only one 

As an early adopter of data fabric technology, the Overall management team are very familiar with the journey to overcome technical challenges, but Tonis is clear that data quality is only a foundational stone of a broader change agenda.

It starts with rewiring the culture of management towards the importance and use of data. This, and understanding what the strategic priorities are and what questions remain unanswered. You need these three qualities: clarity of purpose, data culture, and data integrity all in place before you start to see returns for your investment. For many businesses, the cost and complexity of that change has discouraged them from moving forward.

Final thoughts 

Digital documents, and the data fabric they reside on, offers the necessary blend of tooling for organizations to become data driven. These technology instruments are important, but—as this case example implies—overcoming the cultural, behavioral and strategic planning challenges may still yet be the greater obstacle to success for business leaders prepared to give the data driven business model a try.

Avoid data spaghetti with a no-code aPaaS

Avoid data spaghetti with a no-code aPaaS

No-code aPaaS will transform your data driven decisioning.  Here’s how.

Most enterprises today operate more than 80 SaaS apps, the consequence being ‘data sense’ is harder.  The good news is that you can use a no-code aPaaS platform to bridge across enterprise silos to tame data spaghetti and create a single version of the truth

The problem SaaS exacerbated that no-code aPaaS solves

The short-lived joy of SaaS

data spaghetti graphic

When the possibility of Software-as-a-Service (SaaS) solutions arrived into the market in the early 2000s — heralded in by the evolution of web platforms and cloud computing — they were game-changing for innovators in the tech industry.

Through cloud SaaS innovations, developers could bring their products to market faster (and eat much lower costs), focus on very tight niche solutions, offer products on a subscription, and give customers the opportunity to try them out immediately. Furthermore, technical support and endorsements could be supplied through the same online site that sold the products.

For buyers, SaaS was equally advantageous. No longer did they need to commit to a purchase before experiencing a product to see if it delivered value. The quality of products leaped up the scale, as providers HAD to deliver excellent quality, intuitive, and responsive applications.

The downside of SaaS is that it spreads your data across a wide number of data silos.  

 

SaaS has re-balanced IT selection decisions towards department leaders, but at a cost

Enterprise computing practitioners were somewhat less thrilled by SaaS. Before its arrival, the role of the Enterprise CTO was unquestioned. They were the gods of technology, and nobody could get anything done in IT without their blessing.

The idea that departmental managers could arrive at the IT desk and start demanding software products they hadn’t even seen before, and show them immediate advantages was hard to counter, and left many IT heads on the back foot, trying to defend the common sense of requiring testing, integration and further validation before any recommendation was adopted.

data analytics graphic

The rise of SaaS adoption levels in the enterprise has soared over two decades, as department heads have got ever more involved in selection decisions on the tools they, and their teams, want to use. The power to make decisions drifted from the center of the enterprise to the margins.

Few could argue that the quality of applications used in business has benefited from SaaS.  But at what cost?

Step into any large enterprise and you’ll encounter find the common problem of data held in various SaaS platforms with departmental managers pulling their hair out trying to gather it up to drive decisioning.

Nick Lawrie

Managing Director, NDMC Consulting

image showing a range of encanvas guides

Check out our easy read guides.  Each is crammed with facts and insights on the hottest topics in enterprise IT.

Data spaghetti

Software-as-a-Service technology has played its part in making it close to impossible for real-time business decisioning to happen across the enterprise without an additional layer of ‘business intelligence and analytics’ technology being superimposed.

Even with the best data visualization and analytical tools, the problem of fragmented data silos pervades.

It’s not simply the case that SaaS tools separate usage activity into different places across the enterprise computing biosphere, using a myriad of separately authored apps results in every app using its own core data tables for common things that every organization needs to know about — such as people, departments, organizational hierarchies, policies, processes, suppliers and user groups. While some of these building blocks can be inherited from common directories, most are simply individually reproduced time and again by vendors.

Digital transformation drives data re-use

Growing demand from department leaders and executives for new apps and real-time data analytics has created a demand for data reuse. And it’s when these requests emerge that the problems of data integrity and quality emerge.

Install any new digital innovation into an enterprise, and it’s almost inevitable that existing data will want to be harnessed.

When this happens, time and again, one finds that the original data tables operating within SaaS applications are incomplete, unused, or irrelevant. Business Analysts find themselves scratching their heads trying to work out which bits of data to string together to build a reliable picture of the operating reality.

The state-of-the-art is a right state!

  • Enterprise IT leaders wondering if they will see the day when no department manager comes to the door demanding the next new SaaS thing.’
  • The very same Department managers being given a subscription to Microsoft PowerBI forcing them to spend time away from their customers and teams to clumsily play with rubbish data, wondering ‘Why do I have to spend half my life trying to find data, rather than having the chance to use it?’
  • CxO Executives still struggling to know what processes, policies, and customers actually exist.

Businesses want to be ‘digital’ but lack the quality and integrity of data to innovate.

It begs the question: Is there a better way? The answer is yes — and it’s been around for a while.

Ready to discover the new era of codeless software? Check out our products.

Secure&Live – A feature rich and data secure digital transformation platform.  Secure and Live is a codeless Enterprise applications Platform-as-a-Service (aPaaS), built to turn business models and strategies into apps.

GlueWare –  Enterprise iPaaS for bringing your data together, mashing it up, and bridging between your eCommerce store and back-office, streamlining processes for maximum results.

 

AppFabricBuild as many apps as you need using an agile codeless SDLC approach and change them as often as you like.

Live Wireframe – Design and publish ebooks, courseware and apps, then go live in two clicks!

CDPCodeless Customer Data Platform to create a single view of your customer data. Use our data integration tools to harvest insights from across your enterprise and beyond.  

 

 

work on laptop

Learn about the data safeguarding, features and modules of Encanvas that make it a leader in codeless enterprise aPaaS

Better decisioning starts with a no-code aPaaS to harness data

The rise of no-code application platforms

The concept of cloud Platform-as-a-Service solutions has been buzzing around for over a decade since the arrival of cloud computing. PaaS describes the layer of technology that sits between Software-as-a-Service and the mechanical end of cloud–hardware infrastructure, memory disks and the like. 

A no-code application PaaS is an environment for designing, deploying and operating tens — if not hundreds — of apps and software robots without needing to use code to design, deploy, and run them. 

No-code aPaaS introduces a new skill-set

Using no-code-aPaaS means that Business Analysts found within IT or Digital teams (not coders) author applications.  They do so working in consort with business stakeholders in what Gartner fashionably calls ‘fusion teams.’

Applications requirements go straight from the workshop whiteboard into a live wireframe that swiftly becomes a new application.

Examples of mobile and web desktop applications designed and deployed on no-code aPaaS 

encanvas surface screenshot example_ mobile2
Feature page (light)

What makes no-code aPaaS different to what comes before is that at least 60% of the things you need to produce an Enterprise App come out of the box.  It means the only things business Analysts need to get right are the drag and drop rules, if-then logic and workflows of the application they are building that are unique to the requirement.  While No-Code applications development is fast, building apps on a No-Code Application Fabric is even faster.

Ian Tomlin

Encanvas

No-Code aPaaS is a win: win for both IT and the business

People used to argue you needed a two-speed IT capability to make digital business work.  That notion has thankfully gone away.  No-code aPaaS returns IT influence from the outer fringes of the enterprise to the center.

That’s an awkward conversation in today’s boardrooms, but it’s arguably a necessary one.

Organizations that want to harness data, become data-driven, keep data safe, eradicate self-authored apps and spreadsheets, achieve excellence in customer experience, serve up the best applications for their stakeholders, and cut costs.  History tells us that the best way to achieve it is to have a unified computing and data environment.

pros and cons image

PROs

The benefits of no-code aPaaS for ‘data bridging’

Data quality/integrity benefits include:

  1. Faster data gathering / aggregation using no-code interfaces instead of APIs etc.
  2. Use of integrated no-code Robotic Process Automation (RPA) and Information Flow Automation (IFA) tools to streamline data uploads from remote locations
  3. Safer for data – data is secured at source, during transport, and when uploaded.
  4. Improved data quality through use of artificial intelligence/fuzzy logic tools to cleanse, normalize, enrich and de-dupe data
  5. Easier to test, replicate and scale applications using the provided ‘cloud container’ technology

CONs

The downside (a few things to think about)

1. IT people used to coding will be resistant to change

2. Departmental heads may initially be resistant to the idea of sharing their data

3. Not every no-code aPaaS offers ALL the features you will need. So selecting the right platform with be important and isn’t always straightforward.

ian tomlin profile picture

About Ian Tomlin

Ian Tomlin is a management consultant and strategist specializing in helping organizational leadership teams to grow by telling their story, designing and orchestrating their business models, and making conversation with customers and communities. He serves on the management team of Encanvas and works as a virtual CMO and board adviser for tech companies in Europe, America and Canada. He can be contacted via his LinkedIn profile or follow him on Twitter.

Now read:

Data Fabric: What Is It and Why Every Business Needs One

Data management is important to every contemporary business. Data fabrics present a game-changing, secure solution to managing your data.

Decoupling Data Benefits for Digital Transformation

Decoupling data – what does it mean and why do it? Here’s why CIOs should prioritise decoupling architecture and data fabrics in 2023.

Digital Versus Digitized Documents

In this article, we compare digital versus digitized documents to uncover the big differences between PDF and CDF files.

What can you do with digital documents?

Digital documents are a revolutionary tool enabling digital transformation for businesses. Discover some of the types of digital documents you can create using Encanvas.Rich Media Content ExperienceContent experience documents are all about engaging audiences in more...

Deliver small and wide data with digital documents 

How digital documents deliver small and wide data, allowing data-driven enterprises to optimize their business models and efficiency,

Digital documents and analytics

Every digital business is driven by data. How are digital documents transforming accessibility to the insights executives and information workers need? We investigate. 

How Encanvas helped Overall Eesti become data-driven

Digital businesses want to make informed decisions driven by data. Here’s how Encanvas digital documents helped Overall Eesti achieve that.

Encanvas—A digital platform for digital documents

Encanvas is a leader in enterprise digital platforms for digital business documents. Find out more here.

Avoid data spaghetti with a no-code aPaaS

Learn how to avoid data spaghetti by fully leveraging the benefits of cloud no-code aPaaS solutions that overcome data quality issues.

No-code application development

No-Code Application Development is transforming businesses. But what are you looking for? A no-code design app or an enterprise platform?

get in touch

About Encanvas

At Encanvas we have a passion for low-code / no-code (we like to say codeless) software development. We’ve been leading innovation in the enterprise rapid applications development (low-code / no-code / data mashups) industry since 2002.

Our enterprise digital transformation platform is used to design, deploy and run custom apps by uniquely blending application (aPaaS), integration (iPaaS), Robotic Process Automation (RPA), and data mashup codeless software tools.

Encanvas brings agility and innovation to businesses.  Used by data-driven organizations around the world, our platform evolves digitalization plans at the speed of light to maximize customer experience and minimize IT costs.  Accelerate time to value of new applications as part of your digital transformation or data engineering program.  Read the Encanvas Blog to learn more about what we do.

Re-Invigorating Old Data with Low-Code

Re-Invigorating Old Data with Low-Code

10 Ways DevOps teams are using Low-Code platform to re-use data assets

Without data, you’re just another person with an opinion

W. Edwards Deming, American Statistician

Re-using your data is key to digital project success

Data matters and it’s central to digital transformation. The problem is no matter how much companies invest in their data, and however they capture it, the quality will always be suspect. Without data, any ideas of digital transformation are likely to be a pipe dream.  Low-code is transforming the ability of organizations to create custom apps to cleanse, organize and use their data.

Most companies hoard gigabytes of data on their finances, their products, their customers and markets. The difficulty is that almost no enterprise has its data organized in a structure that makes it easy to access. As soon as business leaders come up with ideas for business model re-invention, probably the next thought in the minds of DevOps leaders is ‘Where is the data coming from?’

Learn more about the ENCANVAS low-code platform by speaking to an expert.

Request Demo

Accessing your data with low-code

Digital transformation projects have a habit of either generating new data (as in the case of sensor network-centric projects) or re-using old data (such as plotting assets or customers on a map and gaining value from location-centric perspectives), or a blend of the two. Re-using data found within the enterprise can be challenging because of data quality issues, the variations of data structures and field formats between applications, and issues getting data out of systems. This means DevOps teams need to have very good data management skills. Low-code platforms offer a smart new way for these teams to harness data that is close by but remains out of reach

Low-code is making data re-use possible

How should DevOps teams approach their data challenges? Here are 10 ways DevOps teams are using Encanvas to breathe new life into their old data.

1. Mashing data from different sources

Old data may be held in various applications and formats. It’s not uncommon for Encanvas to gather information from spreadsheets, big back-office systems databases like SAP R3, IBM DB2, Microsoft Dynamics and SQL – all at the same time. Encanvas is a plug-and-play multi-threaded and multi-sourcing platform which means designers can create concurrent live data feeds from multiple systems or end-points at the same time. This capability is used extensively by designers when creating applications that re-use data from existing and new systems together, creating new data structures on the fly for the specific canvases they author as part of applications under development.

2. Special filters

Your old data may require filtering to select only the records relevant to your project. A powerful feature built into Encanvas’s mashup environment is our special filter which allows designers to employ drag and drop controls to instantly create very powerful data filtering on inbound data from third party sources. Any number of filters can be applied to tables at the same time. For example, if a designer wants to only ingest data from a customer table of a specific type, and that relates to a specific region, they can create special filters for ‘types’ and ‘regions’ selecting only the records that apply to those conditions. All of this rich configuration is done without any coding and doesn’t influence the integrity of the ingested table, or the potential re-use of data in its native form by other applications (or canvases).

1. Mashing data from different sources

Old data may be held in various applications and formats. It’s not uncommon for Encanvas to gather information from spreadsheets, big back-office systems databases like SAP R3, IBM DB2, Microsoft Dynamics and SQL – all at the same time. Encanvas is a plug-and-play multi-threaded and multi-sourcing platform which means designers can create concurrent live data feeds from multiple systems or end-points at the same time. This capability is used extensively by designers when creating applications that re-use data from existing and new systems together, creating new data structures on the fly for the specific canvases they author as part of applications under development.

3. Enriching or validating data with third source data

If your old data can benefit from being enriched by other sources of data, Encanvas’s mashup capabilities can really bring value by making the internal and external data accessible to applications designers without having to use coding or API to build new integrations.

4. Cleansing and transforming data

Sometimes old data requires cleansing at the point of transfer from its original location using a machine to machine cleansing and transforming process to shed unwanted data and apply transformation rules to re-order, de-dupe and re-locate data to new data structures. Encanvas Software Robots make possible machine-to-machine integrations.  They equip designers with the means to configure ETL actions and normalize data before it gets ingested into applications. Our software robots also automate the generation of notices to alert designers (and users too if necessary) that transformations have worked – or not. Transformations can be triggered by events, scheduled times, watch folder changes and a variety of other means.

5. Quarantining data

A powerful (and pretty unique) feature of Encanvas lies in its ability to create quarantining protocols for old data that fails to live up to your expectations for data integrity. There are few good reasons to upload records that are unfit for purpose. If you are gathering customer records for example and would determine that records that fail to have any contact email, telephone or mobile numbers included are not suitable for use, then designers can create quarantining rules that filter this data out for special treatment. In such cases, the data remains ‘in the system’ but is no longer visible to users until it has been manually or machine cleaned.

6. Applying voting systems to ingested data sources and end-points

It may be that old data is being ingested from multiple systems or end-points and you need to create a new data mart that has to prioritize the best likely source of good quality data over others. This can get really complicated because different systems may create new data at different speeds and this can create latency issues but, nevertheless, Encanvas has the codeless tooling to enable designers to author voting systems to vote on which source is most trusted. Voting systems can use algorithms to automatically test data integrity and then automatically augment the voting structure, or they can be manual, where the data owner or manager uses a sliding scale of trust levels to determine which source is proving to generate the best results (or both!).

7. Creating new data

When there are gaps in your old data, there are many ways that Encanvas can create new data as part of its application design. For example, the numeric controls of Encanvas allow designers to create formulas and calculations on data to total columns, sum value, source averages etc. that may be required for your new dashboards and reports but do not exist in the ingested data. Encanvas also has the ability to ingest SQL script and DLLs to make it easy for DevOps teams to re-use existing code blocks or create new APIs and transformations.

8. Location-centricity of data

Another way to create new data is by using Encanvas’s mapping capabilities to apply location-data to existing addresses and locations. Encanvas has an integrated – and codeless – mapping engine (sometimes referred to as Geo-Spatial Intelligence, or ‘GIS’). It allows designers to plot and pin records on maps. The geo-data of records is added to the data-set (companies like Google and Microsoft charge lots of money to do this!).

9. IoT API

Parachute in a high profile technology-centric team with a strong leader into an organization with an existing IT department it’s hardly surprising that you’re going to have to put out some fires and smooth over a few ruffles.

Balancing two-speed IT means having an internal IT team focused on reducing costs and improving process efficiencies through Business Transformation (BX) and a DevOps team re-inventing business models through Digital Transformation (DX) in tandem. Recognizing each team for its own skills and contributions to business outcomes and balancing praise is going to be important for a healthy culture.

10. Building a wholly new data structure

We’ve saved the most dramatic way of fixing old data quality issues until last – because it’s no small project to build a new data warehouse to gather and re-organize data into new structures but sometimes it’s the most sustainable way to ensure that data integrity is preserved for the life of your application. For mission-critical processes, it’s probably the best quality outcome although the time and investment needed to create a data warehouse or enterprise data-hub are definitely ‘none trivial’. Encanvas includes all of the codeless tooling needed to fast-track the creation of new data warehouses and data marts using the data repository of your choice – whether you are moving towards a big data solution like Hadoop or are seeking a more traditional data structure like SQL or DB2.

So there you have it – ten ways Encanvas Low-Code can help you to turn old data into useful data for your next digital transformation.

To find out more about the capabilities of the Encanvas Low-Code platform, please contact our team.

Francesca Manley

Francesca Manley

Author

Francesca is an independent writer and head of communications for technology brands.  Armed with a passion for writing about innovative technologies that can transform business, she serves on the management team of Encanvas and also works as a consultant and advisor to the executive teams of PrinSIX Technologies, Answer Pay and INTNT.AI, helping to rethink their marketing in order to tell their brand story.  She can be reached via LinkedIn.

Curiosity and low-code software apps

Digital businesses need curious minds to power change. How do you leverage your data using low-code software apps serve them?

Re-Invigorating Old Data with Low-Code

Low-Code software development platforms like Encanvas combine aPaaS and iPaaS to breathe new life into old data

Encanvas/4 Released

Introducing Encanvas/4 – the Enterprise-Grade Codeless Application Platform that automates businesses one app at a time.

Charting the rise of Low Code development

Low Code development is a short-hand description for all forms of enterprise high-productivity Platform-as-a-Service (HPaPaaS) solutions.

Low-Code Change Management Software Explained

Change Management Software is a category of application software used to facilitate enterprise change and improvement. It helps organizations to adapt to change by anticipating needs, modifying or displacing incumbent software applications.

Two-Speed IT Or Not, That Is The Question

In this article we debate the need for two-speed IT to drive digital transformation

Low-Code Digital Transformation

Low-Code Digital Transformation

How to move your digital transformation agenda forward with low-code 

Businesses around the world are looking to seize opportunities that the digital era brings. Online communities offer new potential to create wealth. But how do enterprises harness technologies like big data and the Internet of Things (IoT) to turn data into sustainable value for your business?

Digital Transformation is too big and hairy for IT to be expected to deliver it alone.  The problem is, when ‘normal people’ see code on a screen they fee disenfranchised and unable to contribute to software development discussions.  This is why low-code digital transformation is the way to go.

Before considering the tooling though, it’s well worth taking a step further back.  Considering IT changes without first re-visiting the design and fit of business models can result in limited returns from investments in IT. 

‘A business model determines how the created customer value of an enterprise is converted into value for shareholders.  The mechanism that discharges this function is sometimes called the ECONOMIC ENGINE, but fundamentally its about people, process, technology and data.’

Ian Tomlin, CEO – Newton Day

Examples of mobile and web desktop applications designed and deployed on Low-Code digital transformtion platform

encanvas surface screenshot example_ mobile2
Feature page (light)

It takes leadership to make digital transformation to work, but a low-code digital platform makes results easier to achieve

A low-code digital transformation agenda recognises the key role technology has to play in fashioning results.  Using a low-code, or better still ‘no-code’ platform means business stakeholders and system users get to play a key role in software development decisions.  It gives EVERY relevant business stakeholder a say in how to turn your business model into technology solutions, most of all the CEO.

When Chief Information Officers or newly appointed Digital Directors get handed the task of ‘making a digital transformation work’ it can prove to be a poisoned chalice.  Ultimately, it’s the CEO and not IT leaders that should have the biggest say in what business models should apply to an enterprise, and how best to orchestrate them.

The end-game for CEOs is to build or buy a digital platform and ecosystem that represents the digital interface to customers, suppliers and partners.  Within this same ecosystem expect to see technology building blocks to automate business processes, although a fundamental requirement of ecosystems is to make back-office processes more transparent.  Companies like Amazon are demonstrating the effectiveness of built-for-purpose digital platforms to pass over data entry duties to customers, removing many of the back-room processes that traditional suppliers continue to fulfil (unsurprisingly, Amazon doesn’t use Salesforce.com to manage its CRM; its own customer ecosystem removes the need for sales teams to key-fill data). 

One of the challenges CEOs face is understanding the complexities of modern technology, not just in appreciating the applicability of technology for their business models, but during the design and deployment phase when it’s so important that ‘the business’ drives ‘IT’.

This is driving demand for a new kind of agile Digital Platform development tool-set that removes the technical barriers and risks to authoring the kind of Digital Ecosystem that can fully orchestrate a business model.

Use Encanvas AppFabric to supercharge your Digital Transformation

%

88% of businesses say they are already under-going a digital transformation

%

On average middle-managers spend a quarter of their time searching for information... only to find that 50% of the data they find has no value

%

47% of job categories may be taken over by machines in the next two decades.

%

85% of businesses believe that cloud technology will transform their business or industry

%

On average over 60% of enterprise budget is spent on 'keeping the lights on' technology

%

40% of business managers cite a lack of urgency in the company as the biggest barrier to digital transformation

Source:

1. Altimeter Group Digital Transformation Survey
2. University of Oxford
3. Gartner (2112)
4. Gartner (2112)
5. Oxford Economics and SAP (2012)
6. MIT Sloan Mgmt. Review

What form does this new kind of Digital Transformation Platform take?

There are some obvious features we’ve described here; more in terms of what such an ecosystem needs to do in order to orchestrate business models, rather than a technical list.

Remove coding, running large IT teams, gluing technology together

Platforms need a unifying codeless ‘building block’ approach to development that’s fast and affordable; so you can make mistakes and ‘fail fast’

Harvest your existing data assets – and CLEANSE them to make them useful

Fully leverages your existing data assets and makes light work of cleansing data when you start to put it to work!

Easy to use and produces user friendly (iterative) outcomes on any platform

Modern look and feel – Nobody wants to struggle with old fashioned User Interfaces that people can only access when they’re at their desk’

Brings access to the latest tech innovations

You’d expect to leverage big data, artificial intelligence, IoT, data visualizations, software robots…!

‘Enterprise ready’

It will be running business critical apps so it needs to be resilient, scalable and ultra secure – and it needs to be on the cloud!

‘IT department friendly’

Easy to deploy, easy to learn and use, not at risk of creating legacy issues down the line – even better if your IT team trusted it and liked using it!

Where do CEOs start on their digital transformation?

One might argue that it begins with another look at the current business model. Is the incumbent business model maximizing returns to shareholders from the customer value being generated by the enterprise? Furthermore, is the customer value sufficient to keep the enterprise competitive?

One challenge is working out how to articulate the business model into outcomes, capabilities, processes and mechanisms. One of the things the team at Newton Day helps with are Sprint Workshop programs to get through this ‘recognition of needs’ phase as expediently as possible without compromising on accuracy and detail.  It’s essential that enterprises really fundamentally understand who their customers are, what they value and what it takes to deliver results.

Next, a project team and plan has to be constructed..  This should comprise of a blended team of organizational design, HR, risk, legal, IT, marketing, analyst and program management experts.  Whether these individuals are contracted in, or are assigned from existing resources, it’s better to measure their contribution as a team and reward it.  In my opinion, the best governance model for digital platform projects is to have a regular Project Leadership Group (PLG) of senior execs reporting directly into the board and then support this with a Project Steering Group (PSG).

Once this stage is complete, the work to develop the technology ecosystem begins.  This starts with stakeholder workshops and normally, having mapped out the bigger game plan,  projects focus on delivering a point of detail; an aspect of the current business model that can be improved that is seen to be a quick win.  Gaining early results gives everyone inside and outside the project team confidence in the value of the program.

Now, back to the original point: Can a business expect to do all of this without the CEO leading it?  Or, put another way, would a CEO not want to be leading such a strategically important initiative that will be the source of the enterprises income in future years?  I would argue not.

 

ian tomlin profile picture

About Ian Tomlin

Ian Tomlin is a management consultant and strategist specializing in helping organizational leadership teams to grow by telling their story, designing and orchestrating their business models, and making conversation with customers and communities. He serves on the management team of Encanvas and works as a virtual CMO and board adviser for tech companies in Europe, America and Canada. He can be contacted via his LinkedIn profile or follow him on Twitter.

If you've never seen LIVE WIREFRAME in action...

If you’re not already using a code-less design environment then maybe you should see it for yourself. Why not request a fire-side chat and experience ‘across the desk’ applications design close-up with one of our experienced consultants?

Book a Fireside Chat

Unleashing the New Workforce: How Clustered Cloud Can Supercharge Your Team

To deploy and manage your next generation of workers you will need a clustered private cloud architecture. Find out why by reading this article.

Forget Public Cloud: This Private Cloud Innovation is Game-Changing

What are the benefits of adopting clustered private clouds? Find out about clustered cloud benefits by reading this article.

Why Clustered Private Clouds Trump Public Cloud Solutions

Discover how clustered private clouds transform enterprise computing. Design, deploy, manage, scale and govern secure apps, bots and portals.

Data Fabric: What Is It and Why Every Business Needs One

Data management is important to every contemporary business. Data fabrics present a game-changing, secure solution to managing your data.

Decoupling Data Benefits for Digital Transformation

Decoupling data – what does it mean and why do it? Here’s why CIOs should prioritise decoupling architecture and data fabrics in 2023.

What Are Digital Documents?

There’s a new tool helping to organize and generate value from enterprise data. What Are Digital Documents and how can they help your business to win more customers and grow faster? Read this article to find out?

Digital Versus Digitized Documents

In this article, we compare digital versus digitized documents to uncover the big differences between PDF and CDF files.

How digital documents deliver on Gartner’s top 10 data analytics trends

An accelerated pace of change and the need for greater agility is increasing the demand for more consumable analytics. Read our analysis to see how incorporating Digital Documents into your digital strategy is creating digital leaders. Here we look at Gartner’s top 10...

What can you do with digital documents?

Digital documents are a revolutionary tool enabling digital transformation for businesses. Discover some of the types of digital documents you can create using Encanvas.Rich Media Content ExperienceContent experience documents are all about engaging audiences in more...

Digital documents versus apps

Digital documents are a codeless alternative to app dev. What happens when we compare the CDF with traditional app dev tools like FLUTTER?

get in touch