Connectivity

Data Preparer can read or write data to a wide range of databases and file formats, as described in the table.

IntegrationImport Source or Data ContextModify DirectlyExport End Product
Avro--Y*
CSVYYY
DB2YYY
ExcelY-Y
InformixYYY
JsonY*-Y*
MariaDBYYY
MySQLYYY
PostgreSQLYYY
PrestoY--
SnowflakeY--
SQL ServerYYY
URI**Y---

* Containing an array of flat, uniform records at the document root.

** URI Schemes supported: http, https, file, ftp, and sftp.