Connecting to Flat File Systems
Savant supports connections to popular systems that store flat files, including:
• Amazon S3
• Box
• Dropbox
• FTP
• Google Cloud Storage
• Google Drive
• Google Sheets
• Microsoft Excel 365
• Microsoft OneDrive
• Microsoft SharePoint
• SFTP
Uploading Flat Files
In addition to live connections, Savant gives you the option to upload flat files directly into your workspace. This is great for one-time analyses or working with static files that don’t require ongoing updates. Uploaded files are treated as independent datasets and are not linked to a live source, making them perfect for quick tasks or temporary data needs.
Types of Flat Files You Can Connect to in Savant
Savant supports a variety of flat file types, giving you the flexibility to work with your data no matter where it’s stored or how it’s formatted. Here’s an overview of the flat file types you can connect to in Savant:
Excel Files
Excel files are widely used for organizing, analyzing, and sharing data. With Savant, you can:
Access individual sheets or tables from your Excel files for use in your workflows.
Handle multiple tabs or complex formatting easily without manual adjustments.
Text Files (CSV, TSV, etc.)
Text files like CSVs and TSVs are simple and efficient formats for storing structured data. In Savant, you can:
Specify settings such as Delimiter, Text Qualifier, Encoding Format, and Compression to match your file structure.
Combine multiple text files with similar schemas into one dataset for seamless analysis.
Blobs
Blob files, or binary large objects, are used to store unstructured or semi-structured data, such as JSON or XML.
Blobs can be used to retrieve large datasets for processing, making them ideal for cloud-based workflows or managing files that don’t fit into traditional flat file formats.
Google Sheets
Google Sheets offers collaborative, cloud-based spreadsheets, and Savant makes working with them simple:
Connect directly to Google Drive or Google Sheets to access live data.
Select specific sheets or ranges for use in your workflows.