Webmasters Gallery

This article is a sponsored by Flatfile

With the explosive growth of cloud computing over the last decade, unprecedented volumes of data — customer data, product data, statistics, financials, and so on — are being shared between organizations every day. While it would be great if there were a universal API that could guarantee secure and accurate transfer of data, the reality is much more primitive.

Most data that is being shared between companies these days is contained in CSV (comma-separated values) files. While CSVs are generally easy to create, they’re notoriously difficult to secure.

Because of this, the exchange of CSV files has the potential to cause serious problems for companies. And when it comes to user security and privacy, companies can’t afford to gamble on such liability.

How To Create A Secure Data Importer For Your Clients

TechRepublic recently published the findings from a KPMG report regarding data privacy. 64% of respondents said that they don’t believe that companies do much in the way of securing and protecting the data that’s been shared with them.

We know what the solution to this is and how to reduce those justifiable concerns. The first piece is to handle customer data responsibly and be transparent about what you’re doing with it. Regulations like GDPR and HIPAA provide the framework for this.

The other solution is to use technology that prioritizes user security. Just as you’d only add secure data handling features to your digital product — like contact forms, payment processors, and so on — the same applies to your data importer.

CSV importers are already a step in the right direction when it comes to security. Rather than sending email files back and forth over insecure email platforms, companies pass their data through CSV importers. The trick is to build or use a data importer that prioritizes security.

Next, you can find some things your importer will need in order for that to be true.

Protect Your Data With A Secure Infrastructure

When you build a website or app, there are certain measures you take to secure it. One of the most important measures is choosing a hosting provider with the proper infrastructure to support, stabilize and secure your digital product and the data that moves through it.

If you’re building your own data importer, then your product hosting will serve as the underlying infrastructure for it. Just make sure that it is capable of protecting the integrity of your product as well as securing the data transmissions that take place through your importer.

If you’re going to use a pre-built data importer solution, then spend some time reviewing the technology and systems that power it. Your users — and their customers — won’t be too happy if a data breach occurs and you try to put the blame on an external solution.

Here are some things that a secure data importer needs in terms of infrastructure:

Built In The Cloud

Cloud hosting offers a high degree of protection. When reviewing data importer options, take a look under the hood of each to confirm that they’re running in the cloud.

For instance, Flatfile’s servers are built on Amazon Web Services (AWS) cloud infrastructure. As a result, data that passes through Flatfile’s systems is fully encrypted using the AES-256 block cipher. This encryption protects data while it passes through the data importer as well as once it’s stored.

Security Testing And Monitoring

You and your clients aren’t the only ones who should be keeping an eye on what’s going on with your data importer. The company that devised the solution should be doing so, too.

There are a number of ways to ensure that the data importer and its infrastructure haven’t been compromised:

• Application monitoring;
• Continuous logging;
• User action tracing;
• Penetration testing;
• Malicious activity monitoring;
• Automated blocking.

It’s also important to find a data importer solution and provider that will be transparent about detected issues and alert you to any they’ve found.

Resource Management

Application performance goes hand-in-hand with security. This is critical for companies like EmployUS who promise users that their data will be secured, compliant and available.

In addition to reviewing your data importer solution for security features, also look for what it’s doing to optimize performance and uptime.

Load balancing and resource scaling are two things to look for. Another thing you should do is check out the company’s “Status” page. Here’s an example of what the “Status” page looks like for Flatfile:

If there are issues with any aspect of the data importer technology, you’ll find proof of it on this page. Users can also subscribe for real-time updates. Having this level of visibility and transparency is essential when you outsource a critical piece of your application to another provider’s solution.

Ensure Regulatory And Legal Compliance

Different types of digital products have to maintain certain levels of compliance. This can be due to the types of data they handle (like in the medical and financial industries) or because of where they or their users are located in the world.

Whether you’re building your own importer or using a pre-built solution, your technology and data handling processes need to be compliant with all relevant security and privacy regulations.

For example, Flatfile’s solution maintains compliance with the following:

• GDPR
  Although this data security and privacy regulation was passed to protect EU citizens’ personal data, it has far-reaching effects. Because many businesses these days serve customers all around the world, GDPR compliance is essential for anyone doing business online.
• AICPA SOC 2 (Types I and II)
  The Association of International Certified Professional Accountants has its own regulations related to data privacy and protection. SOC and SOC 2 refer to the audit that service providers must pass in order to ensure they’re securely handling employee and customer data.
• EU/U.S. Privacy Shield
  The U.S. Department of Commerce put together this framework in conjunction with the European Commission and the Swiss Administration. It provides companies that conduct transatlantic commerce with a set of data protection requirements to follow when transferring data.
• HIPAA
  HIPAA is a U.S. law concerned with the protection of sensitive patient data. It ensures that their health information is private and secure. It also gives patients more control over how their information is used and to whom it is disclosed.

With so many regulations to stay on top of, a data importer can become a huge chore to maintain and update. This is why many developers and companies choose to use a pre-built data importer solution.

Osmind, for instance, not only streamlined its data transfer process with Flatfile Workspaces, but it enabled them to achieve HIPAA compliance — something that’s critical when working with sensitive health records.

Bottom line: By finding a data importer that maintains various regulatory compliances, you won’t have to spend time down the road looking for alternative solutions to fill in the missing gaps. Plus, a provider that keeps its systems updated as regulations and standards change will greatly reduce the risk of your data importer falling out of compliance.

Prevent Your Importer From Breaking So Easily

Whether you are populating databases for a warehouse catalog, an ERP, or just a list of every town in which you operate, your importer needs to be strong.

For instance, let’s say a user ignores your file preparation instructions and rushes to import the files they have. Before it even gets to the point of cleaning up the data, you want to make sure the importer is able to process it without breaking down.

A broken data importer can leave users with a bad impression of the product they’re using and the company behind it. It doesn’t matter if it’s their fault for not reading the instructions or for poorly formatting their file. Encountering a broken feature is frustrating and can quickly lead to concerns with regard to security and privacy.

“What happened?”
“Did my data even go through?”
“Should I try it again, or is it too risky?”

With how advanced technology has gotten today, users will likely wonder why you hadn’t anticipated these kinds of issues and sorted them out already. So, in order to prevent end users from encountering a broken data importer, it will need to be smart and flexible.

This means using a data importer that:

• Provides no more than a few guidelines so that users don’t have to read an entire manual in order to prepare their files;
• Moves massive amounts of files with thousands of rows of data without erroring out;
• Accepts files just as the customer has prepared them;
• Easily maps and validates data no matter how inconsistent or varied the formats are;
• Detects and notifies you (or your users) of serious errors before uploading.

An importer that breaks down all the time is going to cause issues for everyone involved. So too will one that brings tons of garbled data into your system — especially when that data is mission-critical.

By creating or using a strong and agile data importer, you can reduce the frequency with which errors occur. This will make your data importer more reliable and valuable to your users and help them instill greater trust in their own customers.

Wrapping Up

User security — as well as the perception of how secure the products are that they use — should matter a good deal to companies who collect data from their customers. That’s why it’s essential for developers to use CSV importers that they trust and that won’t put their clients or their end users in harm’s way.

As for whether you should build or buy a data importer, that decision is yours to make. However, if security and compliance are top priorities, then purchasing a pre-built importer like Flatfile would be the more economical and practical choice.