Direct Sync from Collector Offline Data to In-House SQL Database

[FrancisSenyah]

Can someone advise on the best workflow for capturing and syncing Collector data direct to an in-house database with federated Portal?

[PeterTimmers]

And I'm assuming the Federated Portal doesn't have SQL Server in question available to it?

SQL Replication?

FME?

I'm actually planning to take data from our SQL Server SDE behind our federated Portal and move it to another SQL Server SDE.  There are a few ways to do this I'm sure, but I'm using FME because I have more control over the process and I can process the points on the way through.