Typical setup for the salesapp_dss_to_gdc brick

params.json

{
  "dss_jdbc_url": "jdbc:dss://secure.gooddata.com/gdc/dss/instances/something",
  "GDC_USERNAME": "you@gooddata.com",
  "GDC_PASSWORD": "yourpassword",
  "dss_GDC_USERNAME": "you+dss@gooddata.com",
  "dss_GDC_PASSWORD": "yourotherpassword",
  "dss_name_prefix": "sfdc",
  
  "gooddata_model_url": "https://gist.githubusercontent.com/cvengros/a85874dd8f8da034c70d/raw/2441035702459d210b9013b6d1bfe21be3d90de7/salesapp_model.json",
  "dataset_mapping": {
    "account":{
      "source_object":"Account",
      "columns":{
        "id":{
          "source_column":"Id"
        },
        "name":{
          "source_column":"Name"
        },
        "url":{
          "source_column_concat":[
            ":salesforce_server",
            "Id"
          ]
        },
        "region":{
          "source_column":"ShippingCountry"
        }
      }
    },
    "activity":{
      "source_object":"Task",
      "columns":{
        "id":{
          "source_column":"Id"
        },
        "subject":{
          "source_column":"Subject"
        },
        "type":{
          "source_column":"Type",
          "optional":true
        },
        "status":{
          "source_column":"Status"
        }
      }
    },
    "activity_owner":{
      "source_object":"User",
      "columns":{
        "id":{
          "source_column":"Id"
        },
        "name":{
          "source_column":"Name"
        },
        "url":{
          "source_column_concat":[
            ":salesforce_server",
            "Id"
          ]
        },
        "department":{
          "source_column":"Department"
        },
        "region":{
          "source_column":"Division"
        }
      }
    },
    "forecast":{
      "source_object":"Opportunity",
      "columns":{
        "id":{
          "source_column":"ForecastCategoryName"
        }
      }
    },
    "opportunity":{
      "source_object":"Opportunity",
      "columns":{
        "id":{
          "source_column":"Id"
        },
        "name":{
          "source_column":"Name"
        },
        "url":{
          "source_column_concat":[
            ":salesforce_server",
            "Id"
          ]
        }
      }
    },
    "opp_owner":{
      "source_object":"User",
      "columns":{
        "id":{
          "source_column":"Id"
        },
        "name":{
          "source_column":"Name"
        },
        "url":{
          "source_column_concat":[
            ":salesforce_server",
            "Id"
          ]
        },
        "department":{
          "source_column":"Department"
        },
        "region":{
          "source_column":"Division"
        }
      }
    },
    "product":{
      "source_object":"Product2",
      "columns":{
        "id":{
          "source_column":"Id"
        },
        "name":{
          "source_column":"Name"
        },
        "product_type":{
          "source_column":"Type",
          "optional":true
        }
      }
    },
    "stage":{
      "source_object":"OpportunityStage",
      "columns":{
        "is_closed":{
          "source_column":"IsClosed"
        },
        "is_won":{
          "source_column":"IsWon"
        },
        "status":{
          "source_column_expression":"CASE WHEN NOT isClosed THEN 'Open' WHEN isClosed AND isWon THEN 'Won' ELSE 'Lost' END"
        },
        "id":{
          "source_column":"Id"
        },
        "order":{
          "source_column":"SortOrder"
        },
        "name":{
          "source_column":"MasterLabel"
        },
        "is_active":{
          "source_column":"IsActive"
        }
      }
    },
    "activity_monitoring":{
      "extract_sql":"sql/activity_monitoring.sql"
    },
    "opp_records":{
      "extract_sql":"sql/opp_records.sql"
    },
    "opp_snapshot":{
      "extract_sql":"sql/opp_snapshot.sql"
    },
    "stage_history":{
      "extract_sql":"sql/stage_history.sql"
    }
  }
}