Technology works best when it is focused on business solutions
 
RB Consulting, Inc.

Application Integration And Scraping

Modern Solutions Need To Communicate With Each Other

You can only do business with a customer if you communicate. These days that means your systems are the same or can talk the same language. Application integration and scraping data for custom use is another aspect of this common problem. While scraping is another way to integrate applications, it has challenges and often needs specialists. Think of it like a call center that needs to support customers that speak another language. Business is modernizing everywhere and it is forcing even the most ardent defenders of paper filing systems and invoicing into the world of technology. That means your systems need to be able to talk with the systems of vendors, partners, and even customers.

You always have a manual approach to integration. A report can be printed or read from one system and then the data entered into a second one. However, that process is error-prone and time-consuming. Why risk it?

Integration Is Often Over-Simplified

Integration and scraping are ways to map data from one system to another. That process should be as easy as reading an address on a letter and placing it in the correct mailbox. Unfortunately, there is far more to consider than moving data from point A to point B. The integrators must consider validations, data types, rules, timing, and data cleanliness. These issues are sometimes ignored as outlier issues, but that comes with risks. No one wants their processes to fail at peak business time due to a flawed integration. Therefore, going into such projects with partners who understand the challenges is better. 

Experienced partners ask questions and perform the required tests and verification to ensure a successful integration. Data is the lifeblood of modern business and something you should not trust with novices. We have done numerous integrations over the years and take these steps to ensure we provide you with the best solution.

  1. Start with an overview of your business and the problem or problems you aim to solve. We want to ensure there are clearly understood goals and that we are clear on the “why” of the project.
  2. Examine current flows, processes, and any related requirements. We want to clearly understand what is needed, where it comes from, and where it will go. The outcome of this step is often a diagram or flow chart of some form. That picture makes it easier for everyone to understand the process and the solution architecture.
  3. Integration methods are reviewed, and a rough design is created. This step may include one or more proofs of concept to verify that the required integrations work. That often turns up additional requirements and potential data cleansing or transformation that will be needed. 
  4. Data mapping requirements are defined and plugged into the process as a form of test run. This step can require two phases. First, the process is run on paper, where each step is validated for the given inputs and desired outputs. Then, a POC is created to push a single record or a small amount of data through the system. A successful run validates the design and mappings.
  5. The process is executed with sample production data or similar data flow validation from source to target.

These steps can be straightforward when you have little data and only two systems to integrate via a stable, well-defined interface. However, they can take months of development time and discussions when dealing with large amounts of data, multiple integrations, fragile interfaces (like scraping), and other factors that add multipliers of complexity.

Click Here To Schedule a Free 30-minute Call to Discuss How We Can Help. 

Trust And Verify

software on a budget

A process’s good and bad aspects are that automation multiplies the results. Thus, automating a valuable process can quickly add a significant amount of value. On the other hand, a process that contains errors will multiply those errors. We often assume our processes are better than they are. Thus, It is rare to see an integration run flawlessly the first time. Whether the process has flaws or the data itself is flawed, an integration shines a spotlight on them.

Therefore, successful integration requires the implementors to understand the impact of the data they are working with and test accordingly. This requirement is even more critical with less stable approaches, such as scraping data from a site. Numerous iterations will be required, and research afterward to ensure that the source and resulting data are precisely as expected. Even a slight variance in the results (or the source can render the entire process (and, thus, the solution) ineffective or, worse, cause data corruption.