Does the system support data loads like flat-files, i.e. CSV, database, SFTP, and API, for different sources and with field mapping?
- Import data in batch mode from flat files, which is transmitted via SFTP, or directly using data connectors to sources like Salesforce, Oracle, Microsoft Dynamics CRM, etc.
- Use Optymyze web services (APIs) for real-time ingestion of data from external systems
- Define custom field mapping, filters, add/update options, and frequency for each integration with no-code cloud data warehousing, which accelerates setup time and eliminates reliance on data pre-processing or third-party integration tools