File Data Sources

To connect to a file data source, add the required node to the canvas. From the Properties panel, select the way you want to connect to the file: upload the file, connect to a shared file, or connect to a URL.

Supported File Sources

Access

  • Supports local file upload, or pointer to a shared file on a network drive
  • Each sheet within the given Access file is converted into a table
  • Each column within the sheet is converted into a column within the corresponding table

 

  • Click here to learn more about Access datasources.

Excel

  • Supports local file upload, or pointer to a shared file on a network drive, or URL address
  • Each sheet within the given Excel file is converted into a table
  • Each column within the sheet is converted into a column within the corresponding table

 

  • Click here to learn more about Excel datasources.

JSON

  • Supports local file upload, or pointer to a shared file on a network drive, or URL address
  • Each JSON file is converted into a single table

 

  • Click here to learn more about JSON datasources.

Multi Files

  • Supports Text, JSON, XML, and Excel files
  • Supports both local file upload and pointer to a shared file on a network drive
  • To connect to a shared file, enter the extension(s) of the files to upload
  • Each extension must be preceded by an asterisk, and multiple extensions must be delimited by a coma and then a space. For example: *.txt, *.csv
  • Each file must have the same structure (columns) and file type (i.e. Text, JSON, or XML)

  • Note: this data source is not available in the Community Edition.

 

  • Click here to learn more about Multi Files datasources.

Google Sheets

  • Provide the URL link to the Google Sheet
  • It's important that the sheet's sharing preferences are set to 'Anyone with the link' in order to allow Pyramid to access it

 

  • Click here to learn more about Google Sheets datasources.

Sas Data Set

  • Supports local file upload, or pointer to a shared .sas7bdat file on a network drive, or URL address

 

  • Click here to learn more about SAS Data Set datasources.

Text

  • Supports local file upload, or pointer to a shared file on a network drive
  • Supports both Fixed Width Column files, and Delimited files

 

  • Click here to learn more about Text file datasources.

XML

  • Supports local file upload, or pointer to a shared file on a network drive, or URL address
  • Each XML file is converted into a single table

 

  • Click here to learn more about XML datasources.

Connection Type

Uploaded File

To upload a file, either drag and drop the file from its folder location onto the Properties panel, or click the blue Upload File button, and then find and select the file from its folder location.

Shared File

Users can provide a pointer to a shared file, rather than uploading the file into Pyramid. When the model is processed, the file is read and included in the model.

To connect to a shared file, enter the shared file path in the Properties panel. The shared file must use a UNC file path format to the shared directory and file on the network. The machine hosting Pyramid must have access to the shared file location. If the Pyramid services are running on different machines, the Runtime and Task Servers must be given access to the shared file location.

URL

The data will be downloaded from the URL when the model is processed. To connect to a URL, enter the URL and its required authorization:

  • None: select None if no authorization is required
  • Basic Authentication: if basic authentication is required
  • Custom Header: if custom header authorization is required

Table Selection

From the Table Selection panel select the tables that should be added to the Data Flow.