article thumbnail

Migrate Microsoft Azure Synapse Analytics to Amazon Redshift using AWS SCT

AWS Big Data

To connect to the Azure Synapse source data warehouse, choose Add source. For Connection name , enter a name (for example, olap-azure-synapse ). Select Redshift data agent , then choose OK. For Host name , if you installed the extraction agent on the same workstation as AWS SCT, enter 0.0.0.0 to indicate local host.

article thumbnail

What Is Embedded Analytics?

Jet Global

Data Environment First off, the solutions you consider should be compatible with your current data architecture. We have outlined the requirements that most providers ask for: Data Sources Strategic Objective Use native connectivity optimized for the data source. Requirement ODBC/JDBC Used for connectivity.