I would like to load SFDC data (I have the connector working) but because the data sets are so large I need to limit the data loaded e.g. get only SFDC opportunities created in 2015. I was trying to use the data connector wizard but there isn't an option to filter within it. Might someone be able to share a simple sample SFDC data load script that uses filter to limit data load by date to get me going? I have a feeling that this is accomplished with SQL or SOQL but I'm not well versed in these queries...
I today stage my SFDC data in excel and it is too cumbersome for refreshes.
I don't know these connector but assume it will be based on sql - therefore should your query look like this:
SQL Select Field1, Field2, Field3 From YourSFDC where year(created_date) = 2015;
This meant you need to manually adjust the output from the wizard to the above where-clause (you might need to adjust the fieldname for your date-field, too or if there is a year-field available you could use this).