File Data Source PivotData Microservice Documentation


Microservice settings are specified in the appsettings.json file.

Cube config for SQL database should have additional "SourceFile" section:

{
  "Id": "AdventureWorksOrdersCsv",
  "Name": "Adventure Works Orders (CSV)",
  "SourceType": "File",
  "SourceFile": {
    "Name": "App_Data/adventure_works_order_details.zip",  /* relative path is resolved to working dir */ 
    "Type": "Csv"  /* possible values: Csv, SerializedPivotData */
   },
  "InferSchema":true
}

CSV file separator (comma, semicolon, tab) and file encoding are determined automatically. Data file may be compressed with Gzip or Zip (if zip contains several files only first one is used).