Data Loading Roadmap: Choosing a Data Loading Method¶
There are a number of ways you can load data from external sources into the Actian Data Platform. Depending on your data source and location, choose a data loading method and follow the link to the appropriate how-to information.
| Your Data Source or Format | Data Location | Data Loading Method | UI-based | Recommended for Large Data Sizes (> 1 GB) | See |
|---|---|---|---|---|---|
| Delimited text | Desktop | Data Load (Azure and Google Cloud only) |  |
Not recommended over 100MB | Data Load |
| Cloud storage | SQL | |
Loading Delimited Text Data from Cloud Data Storage | ||
| Cloud storage: • AWS S3 • Azure Blob Storage • Google Cloud |
Batch data loading | |
Batch Data Loading | ||
| • JSON • NoSQL |
Cloud storage | SQL | |
Loading JSON Data from Cloud Data Storage | |
| • Parquet • Avro • CSV • HIVE • ORC • JDBC |
Cloud storage | SQL | |
• Loading Parquet Data from Cloud Data Storage • Examples of Defining External Tables and Loading Data |
|
| Web applications | • NetSuite • Salesforce • ServiceNow |
Batch data loading | |
Batch Data Loading | |
| Databases | Actian Zen | Batch data loading | |
Batch Data Loading |
You may also choose between the following data loading methods.
Loading delimited text file data using the Actian Data Platform automated data integrations
- Data Load (Azure and Google Cloud only)
-
- –Using Actian Library Templates for Loading Data to Avalanche
Loading data from external tables in cloud storage using SQL