Currently, the Pardot connector can only authenticate and connect to production Salesforce/Pardot (login.salesforce.com).  The user should be able to indicate whether they want to connect to Production or Sandbox.  If Sandbox is chosen, Fivetran would start with test.salesforce.com instead.