Automation of workflow using connector BR

If I understand this correspondence, you want to automate the data load of a Workflow that is bringing in data through a Data Connector.  If that is the case, yes, you can automate this process.  

1.  Create an Extensibility Rules Business Rule.  You will probably want to create the logic under Unknown and ExecuteDataMgmtBusinessRuleStep.  This is so the logic executes manually and during the execution of a Data Managment Step.  For example:

Select Case args.FunctionType
Case Is = ExtenderFunctionType.Unknown, ExtenderFunctionType.ExecuteDataMgmtBusinessRuleStep

The BR would use a trigger file with the naming convention for Workflow Name, Scenario, and Time to identify where to load data to.  Set the processing switches ( Import, Transform, Load Cube, Process, Confirm etc ) to perform as part of the data loading process.  Then execute the batch

2.  Create a Data Management Sequence and an Execute Business Rule Data Management Step and assign the Extensibility Business Rule to the Data Management Step.  There is an example of this setup in the Golfstream Reference app.  It is under Data Management called Batch File Loading

3.  To automate, setup a New Task in Task Scheduler.  This is under Application > Tools > Task Scheduler.  This is where you can automate how often you want this process to execute.  

I believe Task Schedule was a new feature starting in 6.4 or 6.5 so you will need to be on, at the minimum, one of those versions.  If not, you can use PowerShell to execute the automation.  

Hope this answer addresses your question and points you in the right direction.