CSV Integration Configuration
1. Connector
2. Parser
3. Mapping
4. Validation
5. Persistence
CSV Source Configuration
File Location
Connection Type
Local Folder
SFTP
File Name Pattern
Sync Trigger
On Startup
Scheduled
Manual
Protocol
HTTPS
HTTP
Host
Port
Retries
Proxy (optional)
CSV Parsing Configuration
Delimiter
,
;
|
Encoding
UTF-8
ISO-8859-1
Has Header
Yes
No
Quote Character
Escape Character
Date Format
Decimal Separator
Columns
Column Name
Data Type
String
Date
Number
✖
Add Column
Mapping / Transformation
Client Field
System Field
Transformation
✖
Add Mapping
Validation Rules
Required Fields
Date Format
On Error
Skip Record
Stop Process
Log Only
Persistence
Target Table
Mode
Insert Only
Upsert
Replace