Posted on January 14, 2020 | | Categories: Managed File Transfer
It's happened to us all – you start a free software trial, only to get stuck at step 2: what to do first? Plotting a plan of attack before your first login can help you get the most out of your limited time with the product (and might even help you down the line when you're making the case for adoption to your internal stakeholders).
Whether you don’t know where you’d start with managed file transfer software or you have too many potential projects to tackle in 30 days, we can help! Keep reading for overviews of popular projects that users often tackle first when getting started with a GoAnywhere MFT trial.
Reading CSV files and importing the data into a database is simple with GoAnywhere Projects. “Read CSV” is one of the many options available in GoAnywhere’s Component Library, which lets users drag and drop actions into new projects. Once the database server, SQL statements, any queries, inputs, and outputs are specified, users can execute the project and import the CSV data directly to the database.
GoAnywhere lets you correct and adjust formatting before the data is transferred from the source CSV file to the database. For instance, if you receive dates in a format that MySQL doesn't expect, you can add a step to format the data into the appropriate format.
One organization uses this feature to manage an employee benefit trust fund – data is automatically pulled from decrypted files sent to their SFTP server and added to a database, which triggers a notification email to the solution administrator.
For the complete instructions, see the tutorial How to Import a CSV File into a Database.
Related Reading: 20 Managed File Transfer Project Ideas
GoAnywhere parses each level of objects, arrays, and various field data contained in a JSON file and stores the contents in one or more RowSet variables. For each type of JSON file that needs to be imported, easily set how each piece of information should be read and stored in your database. Then, lay out how each RowSet should insert the data into database tables.
Walk through the process step-by-step using the tutorial How to Read JSON Data and Insert It Into a Database.
Healthcare organizations, banks, and even state governments encrypt their files using Open PGP thanks to GoAnywhere MFT. Whether you’re protecting patient data, financial information, or overseas military members’ ballots, you can ensure file safety with Open PGP.
Store sensitive information or transfer data across any network knowing that only the intended recipient will read it.
Import your trading partners’ public keys, create new keys, and securely export PGP keys with the GoAnywhere Key Management System. Create a Project in GoAnywhere to encrypt using the PGP Encrypt task. Then:
This Project is now ready to encrypt any file to send to your trading partner. You can also sign files using Open PGP to show that you are the true originator of the documents.
Get started with Open PGP and read the full tutorial How to Encrypt Files with Open PGP.
With GoAnywhere, there are many different ways to automate your processes:
Related Reading: 30 Ways to Simplify Life with Advanced Workflows
End users can fill out custom forms and even upload files with ease through Secure Forms, allowing them to safely submit data to your enterprise. Build a form with the fields you need, and then set up a workflow that will immediately process the data whenever the form is submitted. You can even limit the users who have access to specific people or make the form publicly available.
Get creative with how you collect data, and check out how other enterprises have implemented Secure Forms to easily gather and organize secure information with our blog 3 Ways Your Peers are Using Secure Forms.
The only difference between GoAnywhere MFT's live and trial versions is how long you get to use it – see how GoAnywhere can simplify and streamline your processes with the robust software either in the cloud or with a local install.