Working with Writer

Every Transformation created must have at least one writer object. The writer connects to the Target database and loads data into it. Depending on the target type some options may not be available. To change the Writer properties click or double-click on the Writer object.

• Target type is a Text File
• Generating Insert Statements
• Target type is a XML File
• Target type is JSON
• Target type is Excel File
• Target type is QlikView QVX File
• Target type is QlikView QVD File
• Target type is MS Access
• Target type is DBF
• Target Type is ODBC Connection
• Target type is Ole DB
• Target type is SQLIte
• Target type is MS SQL Server
• Target type is MS SQL Server CE
• Target type is Oracle
• Target type is MySQL
• Target type is PostgreSQL
• Target type is Interbase/Firebird
• Target type is File System
• Target type is SMTP Server
• Target type is IMAP4 Server
• Target type is Office 365 Email Server
• Target type is SalesForce
• Target type is Slemma
• Target type is HL7 Server
• Target type is BDE
• Target type is a SMS
• Target type is a Microsoft Message Queue
• Target type is RabbitMQ
• Target type is a Tableau TDE file
• Target type is a Tableau Hyper file
• Target type is Google Spreadsheet
• Target type is a Stored Procedure
• Generating Primary Keys and Defaults
• Running SQL Scripts
• How to Update/Delete Records