After reading this article, you will be familiarized with the practicalities on how to bring your internal data get exposed to the external consumers (i.e.: partners, vendors and/or any kind of consumers) in a secured way.

We strongly believe that the approach we made is quite practical “and is simple” that solves an important scenario in relation to SFTP. It might be a big help to you, therefore, we wrote this article.

Such kind of solution is done completely in a matter of few hours, in which historically it is extremely tedious and painful to realize.

Think of these things…

You write few lines of code and had accomplished the complex job in a very short time. The solution is dynamic, adaptable to any changes (both schema, data and/or data stream). The partner is happy!

Disclaimer: The information on this article may not work and applicable in all cases, but the technique can be leveraged on how you do your own solutions. Any recommendations and suggestions can be discussed, but the contents will only be limited based on our intent.

Target Requirements and Scenarios

It is important for you to know the actual scenarios and problems the solution on this article is addressing.

• You have the databases residing within your internal network (on-premise/cloud).
• Your consumers are looking for the raw-data (not changed, nor harmonized).
• Your consumers require the data to be delivered frequently.
• Your consumers agreed with the file format delivery (i.e.: CSV format).

Also, your consumers are agreeing to any changes on the schema or data/data-type, for as long the data is arriving in a frequent manner, as agreed.

#csharp #programming #technology #data-science