File Writer agent

The File Writer agent exports data from a Prophix source table to other systems, through an export file.

The File Writer agent offers customizable options for enclosing selected columns in quotation marks: by default, all the columns are wrapped in double quotes, but you can choose which columns to exclude (useful when dealing with systems that do not accept double quotes for numeric values).

A File Writer agent can only be used as a source and can connect to the following destinations:

  • Excel
  • MySQL
  • ODBC/ODBC32
  • SQL Server
  • Text

Add a connection

To add a connection for a File Writer agent:

  1. In the navigation panel, select Setup.
  2. Select a text agent or peer connection, and click > Add Connection.

  3. Connection Name must be unique. Up to 40 characters.

     Note:  All the parameters listed below are required; none have character restrictions.

  4. Version determines the predefined script the agent uses. If available, select the version you want to use.
  5. Click Save.

Add a query

  1. Select a File Writer connection or peer query, and click > Add Query
  2. Query Name must be unique. Up to 40 characters.
  3. From Query Type accept the default option, Export File.
  4. In the Filters table, define the rows in Default value as follows:
    • Table Name: The default name of the export data source table.
    • File Name: The name for the export text file (include the .txt suffix).
    • Fields: Optionally, the names of fields you do not want wrapped in double quotes—typically these are numeric-value fields; separate the names with commas.
  5. Sample value: What the user sees when hovering over the cell in the Data Integration process. Use it to show the expected input/format. Up to 50 characters.
  6. Hide: Turn on if you want to keep users of the Data Integration process from seeing the parameter, while using its Default value in the query.
  7. Click Save.