Some additional connection properties could be set in Syniti Replicate to support AWS Azure Data Lake Gen 1 and Gen 2.
|Use Column Names||Determinates if the output CSV files generated during replication will contain the list of column names in the first row.|
|Add Transactional Info||Determinates if the output CSV files generated during replication will contain transactional info columns (operation type, transaction id, transaction timestamp, transaction user, etc) and if these information will appear at the beginning of the record.|
|Transactional Column Prefix||Prefix to add to transactional fields (if selected). This option will allow using a custom format for the transactional fields to distinguish them from the data fields|
|Serialization||Define the type of serialization required for the Azure Data Lake:
|Column Separator||[CSV Only] Indicates the character used as column separator in the CSV file.
\t = Tab Separator
, = Comma
| = Pipe
|Column Escape||[CSV Only] Indicates the escape character used for the column separator. Default backslash (\). Editable value.|
|String Separator||[CSV Only] Indicates the character used as string separator in the CSV file. Default quotation marks ("). Editable value.|
|String Escape||[CSV Only] Indicates the escape character used for the string separator. Default backslash (\). Editable value.|
|Compression||[Parquet Only] The Parquet compression method used.
0-None: No Compression.
1-Gzip: Offers the highest compression ratio, it is not splitable and takes sometimes to encode and decode.
2-Snappy: Offers less compression but is splitable and quick to encode and decode.
|Use Nullable Fields||[Parquet Only] Allow Nullable fields.|
|Use DateTime Fields||[Parquet Only] Allow DataTime fields.|
|Use One File Per Group||Indicates if each replication group generates a common CSV file or one file for each replication in the group.|
|Extended Properties||Additional properties not listed in the grid. Enter the properties as a list of "property=value" string separated by ";".|