Skip to main content
VC-Virtual Communications Limited

Systems Integration

Connect the systems your business already relies on

VC develops integrations that let your CRM, practice management platform, accounting software, mobile applications, databases and legacy systems exchange information reliably. Staff then no longer have to move it between them by hand.

Illustrative integration map. A CRM, spreadsheets, accounting software, a legacy database and a mobile app all connect to a central secure data bridge. Data then passes a validation checkpoint, where exceptions are flagged for attention, before reaching the central platform.

The basics

Making separate systems work as one

System integration is the work of connecting separate software systems so they can share information. Without integration, people act as the connection: exporting from one system, re-keying into another and checking that the two match. With integration, information moves between systems automatically, in a defined and controlled way.

Integration doesn’t always mean real-time, two-way synchronisation. Sometimes a scheduled one-way transfer is simpler and entirely sufficient. The right design depends on what each system allows and what the business needs.

Without integration

Export, re-key, then check that the two systems match.

With integration

Information moves automatically, in a defined and controlled way.

How it works

The building blocks of a reliable integration

  • APIs

    An API (application programming interface) is a defined way for one system to request information from, or send it to, another. Most modern business software offers an API, and it is usually the preferred integration route.

  • Secure data bridges

    Where systems can’t connect directly, a data bridge acts as the go-between. It collects information from one system, transforms it and passes it securely to another.

  • Data mapping

    Different systems store the same information in different ways. Mapping defines how fields in one system correspond to fields in another, for example how a “customer” in one relates to a “client account” in another.

  • Synchronisation

    Keeping information consistent across systems, whether in near real time or on a schedule, and deciding which system is the source of truth for each type of data.

  • Data transfer

    Moving information between systems securely and in the right format.

  • Validation

    Checking that information is complete and correct before it’s accepted, and flagging anything that isn’t.

  • Cross-platform connectivity

    Linking web applications, mobile applications, databases and third-party platforms so they work together.

Data mappingExample data
Example mapping between fictional fields in an existing system and a new platform
Existing systemMaps toNew platform
CustomerClient account
Cust_PhoneTelephone
Contact_NamePrimary contact
Invoice_AddrBilling address
Date_AddedAccount opened

Field names are fictional. Real mappings are defined for each pair of systems.

Accounting

Connecting operations and finance

When operational systems and accounting software are separate, the same figures are often entered twice. Time and project costs are recorded in one place, then invoices and financial records are prepared in another. Integration lets the two exchange information.

VC’s documented work includes accounting-system integration, including integration functionality for platforms such as Xero and QuickBooks. Depending on the platforms and your requirements, integrations can support:

  • Invoice information

    Preparing or passing invoice data based on project and time records.

  • Project cost data

    Bringing cost information together with project work.

  • Profitability information

    Combining operational and financial data to show how projects are performing.

  • Accounting records

    Keeping relevant records consistent between systems.

  • Reporting data

    Feeding financial information into dashboards and reports.

Xero and QuickBooks are trademarks of their respective owners. Naming them does not imply a partnership or endorsement.

Legacy systems

Moving on from older systems without losing history

Older systems often hold years of valuable information. Moving to a new platform, or connecting old and new, needs care:
  1. 01

    Extracting historical data

    From the existing system, in a usable format.

  2. 02

    Mapping old fields to new fields

    So information lands in the right place in the new structure.

  3. 03

    Validating information

    Identifying gaps, duplicates and inconsistencies before migration.

  4. 04

    Migrating client histories

    Including related records and file mapping.

  5. 05

    Connecting old and new systems

    Where both need to run side by side for a period.

Mobile

Connecting mobile applications to your platform

Mobile applications don’t usually talk to a database directly. They go through an API:
Mobile app, then API, then CRM or central platform, then database.
  1. Mobile appStaff on the move
  2. APIControls requests, applies permissions, secures transmission
  3. CRM / central platformStays in control of the data
  4. DatabaseWhere information is stored

The API controls what the mobile application can request or change and applies the user’s permissions. It also keeps data transmission secure. This lets staff work with live business information from a mobile device while the core platform stays in control.

Data integrity

Why validation matters

An integration is only as useful as the data it moves. If incorrect information passes silently from one system to another, the error spreads, and it can be harder to trace than a single typing mistake. Good integrations:
  1. Validate data before accepting it;
  2. Handle errors predictably and flag them for attention;
  3. Avoid creating duplicates;
  4. Keep a clear record of what was transferred and when;
  5. Are tested end to end before going live.
Validation checkpointExample data
  • Record 1021 · Client BAccepted
  • Record 1022 · Client FMissing email, flagged
  • Record 1023 · Client BDuplicate, not created
  • Record 1024 · Client HAccepted

Transfer log, 14:05: 2 accepted, 1 flagged, 1 duplicate prevented.

Example architecture

How the pieces fit together

This is an illustrative example. The right architecture depends on your systems and requirements.
Example integration architecture in four tiers: existing systems, then the integration layer, then the central platform, then outputs.
  1. Tier 1

    Existing systems

    For example, current CRM, accounting platform, legacy databases and spreadsheets.

    • Current CRM
    • Accounting platform
    • Legacy databases
    • Spreadsheets
  2. Tier 2

    Integration layer

    APIs and secure data bridges that handle mapping, validation and transfer.

    • APIs
    • Secure data bridges
    • Mapping
    • Validation
    • Transfer
  3. Tier 3

    Central platform

    The core business application and database that hold the organisation’s working information.

    • Core business application
    • Database
  4. Tier 4

    Outputs

    Reporting, mobile access, finance and CRM, each drawing on consistent information.

    • Reporting
    • Mobile access
    • Finance
    • CRM

FAQ

Systems integration questions

What’s possible depends on the systems involved. Each is normally assessed during discovery, and the options explained.
What is an API?

An API (application programming interface) is a defined set of rules that lets one piece of software request information from, or send information to, another. It works like an agreed contract between systems: which data is available, in what format, and who is allowed to access it.

Most modern business applications, including many accounting and CRM platforms, provide APIs. They are usually the most reliable way to integrate systems.

Can VC connect existing software?

In many cases, yes. It depends on what the software allows, for example whether it has an API, supports data export or can be connected through a secure data bridge. Each system would normally be assessed during the discovery and requirements stage, and the options explained.

Can CRM and accounting systems be connected?

Yes. Accounting integration is part of VC’s documented work, including integration functionality for platforms such as Xero and QuickBooks. What can be exchanged, such as invoice information, project costs or financial records, depends on the platforms and your requirements.

How is data transferred between systems?

Usually through APIs, which exchange structured information between systems in a controlled way. Where that isn’t possible, a secure data bridge can move and transform information on a schedule. In both cases the design covers data mapping, validation, error handling and security.

Can legacy data be migrated?

Usually, yes. Migration involves extracting historical data, mapping it to the new structure, validating it and migrating it, including client histories and related files. The effort depends on the format and quality of the existing data, which would normally be assessed before an approach is agreed.

What happens if an integration fails or receives bad data?

A well-designed integration validates information before accepting it and handles errors predictably. It flags problems for attention rather than passing incorrect data on silently. Monitoring and logging help identify and resolve issues. Monitoring and logging requirements would normally be defined as part of the project.

Can VC integrate with software that does not have an API?

Sometimes. Where a system has no API, other routes may be available. These include scheduled data exports and imports, direct database access where appropriate and permitted, or a secure data bridge that collects, transforms and passes information between systems.

These routes are usually less flexible than an API and may involve scheduled rather than immediate updates, so they need careful design around validation and error handling. Whether a practical route exists depends on the software, how it stores data and any restrictions set by its supplier. This would normally be assessed during the discovery and requirements stage.

What happens to our existing data during migration?

Migration normally follows a structured sequence. Historical data is extracted from the existing system, mapped to the fields and structure of the new system, validated to identify gaps, duplicates and inconsistencies, and then migrated. Client histories and related files can be mapped so that records remain connected in the new system.

Test migrations are commonly used so that results can be checked before the final move, and the existing system is typically left in place during this process. If old and new systems need to run side by side for a period, the approach is agreed as part of the plan. How straightforward migration is depends largely on the format and quality of the existing data.

What information is needed before assessing an integration?

It helps to know which systems need to be connected, what information needs to move between them, in which direction and how often. It is also useful to know whether each system offers an API or data export, who supplies and manages each system, and roughly how much data is involved.

Examples of the data, a description of the current manual process and any known problems, such as duplicates or inconsistent records, also help. You don’t need all of this before getting in touch. These details would normally be gathered during discovery.

Next step

Which systems do you need to connect?

Tell us which systems hold your information today and where staff are moving it by hand, and we can discuss the integration options.