File List Connector > File List Connections > Creating a File List Connection
  

Creating a File List Connection

To use File List Connector in a synchronization task, you must first create a connection in Data Integration.
You can configure a connection on the Connections page or in a wizard as you configure a task.
    1. On the Connections page, click New Connection to create a connection.
    The New Connection page appears.
    The following image shows the Connection page:
    2. Specify the following details:
    Connection Property
    Description
    Connection Name
    Enter a unique name for the connection.
    Description
    Provide a description for the connection.
    Type
    Select File List from the list.
    Secure Agent
    Select the Secure Agent from the list.
    File Type
    Select the file format from the list. The connection supports fixed-width and delimiter file types.
    Delimiter
    Select the delimiter. The default delimiter is Comma.
    Schema File Path
    Specify the schema file path. A sample schema file is present in Informatica Secure Agent folder. The path is <Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\tomcat\plugins\<plugin ID>
    Custom Header File Path
    Specify the header file path. You can find header.hdr file in Informatica Secure Agent folder. The path is <Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\tomcat\plugins\<plugin ID>
    Skip First N lines
    Specify the number of rows you want to skip while merging the files. This helps you to skip the rows from the beginning of the file.
    Skip Last N lines
    Specify the number of rows you want to skip while merging the files. This helps you to skip the rows from the end of the file.
    Merge File Path
    It is the file which contains details of all the multiple files you need to merge using the File List Connector.
    Provide the path where this file resides. The following image shows a sample of merge file path where file1 and file 2 are the two files to be merged:
    Rows Per Batch
    Mention the required batch size to optimize the performance. The default value is 100.
    Date Format
    Mention the Date format. The default date format is dd-MM-yyyy HH:mm:ss.
    3. Click Save to save the connection.
    You should test the connection before you save the connection details. You can click Test Connection to verify if the connection is successful.