Alooma can replicate tables from your Microsoft SQL Server (MSSQL), either hosted by you or in Amazon, to your target data warehouse in near real-time.
This enables you to, for example, enrich your analytics data coming from your mobile devices and with user attributes stored in your MSSQL database.
Alooma provides all three supported replication options for MSSQL: full dump/load, incremental, and log based replication (relying on the MSSQL feature called Change Tracking). Learn more about choosing the right replication method for your data.
If you've chosen log replication, you'll first have to take a few steps to set up your database.
If you've chosen either the full dump/load or incremental replication option, you can skip to connecting to Microsoft SQL Server.