Adding Data in a CSV to Vendia Share Using Email

Business people, hands and writing in office meeting for planning, calendar or agenda on sticky note. Plan, visual and creative person team in collaboration for solution, brainstorming and innovation.
Posted by
Business people, hands and writing in office meeting for planning, calendar or agenda on sticky note. Plan, visual and creative person team in collaboration for solution, brainstorming and innovation.

In Part 1 of our series about Integrating Data Stores with Vendia Share, we dove into adding a CSV via Email, but what about adding data via STFP? We can help with that!

What is SFTP?

The Secure File Transfer Protocol (SFTP) provides reliable data and large file transfers over the web. SFTP is regularly used when transferring sensitive information like PCI, PHI, financial records, or research. Thus it is no surprise that STFP is the standard for financial systems, and health services that have to comply with HIPAA.

SFTP in Health and Financial Services

For example, let’s say a hospital needs to relay results from a sponsored study to their partnered pharmaceutical company. Most likely, they will use a STFP to transfer the relevant data. STFP ensures a secure and accurate transference of sensitive information.

Similarly, financial companies have their own risk-mitigation and security measures to prevents information leaks. They also have to follow strict compliance protocols when transferring sensitive information like payment records. Thus, SFTP is a popular way to transfer payment records and financials from one institution to another.

Vendia Share and SFTP

Sr. Solutions Architect, Brian McNamara, provides a step-by-step guide for adding files via SFTP to Vendia Share.

The guides uses the Vendia Share Command Line Interface (CLI) and the AWS Serverless Application Model (SAM). Serverless resources like a AWS Transfer for SFTP endpoint, AWS S3 bucket and AWS Lambda function will be deployed. CSV processing with a AWS Lambda function will be triggered by transferring a file to the SFTP endpoint. The Lambda function parses CSVs and publishes data to a node’s GraphQL endpoint.

Diagram of SFTP to Vendia Share Integration

Search Vendia.com