Creating an Excel Source

Published: Sep 12, 2018

Creating an Excel Source

Published: Sep 12, 2018
  • From the left side options column navigate to Date Sources > Bulk Sources > File.

    +091118 2319 CreatinganE1

  • On the File Data Sources window click on the +Create Bulk File button.

    091118 2319 CreatinganE2

  • On the New File Data Source window click on the Microsoft Excel icon.

    091118 2319 CreatinganE3

  • The Microsoft Excel Data Source window contains the following fields:
    • Description – allows the user to enter a description of the spreadsheet being imported.
    • Select file at runtime – When this checkbox is marked, the uploaded file will be used as a template only and no data from it will be processed. The files chosen at runtime will need the same headers as the uploaded source file.
    • Source File – Click on the Select File … button to select the Excel file to be used as the data source.
    • Excel Sheet – After the Source File is selected, the Excel Sheet field will become active. Use this field to select the worksheet in the Excel file to be used as the data source.

    091118 2319 CreatinganE4

  • Once all the fields have been populated, the Save button becomes active.
  • Clicking on Save will save the data source and make the data source available to be selected when creating an Integration Process.
  • After the Excel source has been saved, the Preview button will become active.
  • Click on the Preview button will open a pop-up window that displays the first few records contained in the spreadsheet.

    091118 2319 CreatinganE5

  • Closing the Data Preview window and Excel Data Source window returns the user to the File Data Sources window where existing data sources can be edited or deleted by clicking on the respective icons.

    091118 2319 CreatinganE6

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Reset Filters