Fivetran enables users to move relational databases, including Microsoft SQL Server, to Google Cloud BigQuery for analysis with tools like BigQuery ML. To set up this automated fraud detection system, Fivetran is used to connect to a SQL Server database and transfer the credit card transactions dataset to BigQuery for use with BigQuery ML. The process involves selecting specific datasets and columns from the original SQL Server data, configuring incremental changes and schema drift, and setting up a new dataset in BigQuery. Once the data is moved, users can create and run machine learning models using BigQuery ML to detect fraudulent transactions. This solution provides centralized data, modernized infrastructure, and scalable ML applications for combating credit card fraud without requiring setup or maintenance.