topic Re: Prerequisite for Microsoft SQL Cloud in Data Movement & Streaming

Prerequisite for Microsoft SQL Cloud

harsh2 — Wed, 19 Mar 2025 22:43:16 GMT

Hi community team,

do we have Prerequisite for Microsoft SQL cloud

or do we have to follow the same as Microsoft SQL server on prem for QCDI

Thanks,

Harsh Patel

Re: Prerequisite for Microsoft SQL Cloud

TimGarrod — Thu, 11 Jan 2024 21:18:07 GMT

When you say Microsoft SQL Cloud - do you mean Azure SQL DB, or Azure SQL MI or running SQL Server in a VM in Azure or another method of SQL server in the cloud?

Re: Prerequisite for Microsoft SQL Cloud

harsh2 — Fri, 12 Jan 2024 03:32:56 GMT

Hi @TimGarrod ,

I am talking about azure SQL db(managed cloud database)

Specially in my scenario aws SQL db

Re: Prerequisite for Microsoft SQL Cloud

harsh2 — Fri, 12 Jan 2024 03:43:42 GMT

Hi @TimGarrod

Also I have one question

For SQL Server in a VM in Azure

We have to use on prem prerequisite as it is installed in windows , right?

Re: Prerequisite for Microsoft SQL Cloud

TimGarrod — Fri, 12 Jan 2024 14:00:58 GMT

For SQL Server in a VM - yes you treat it just like on-premise SQL Server as far as pre-req's go.

for Azure SQLDB (I'm a bit confused cause you mentioned Azure, but then AWS ? ) - it is recommended to use the CDC based connector. This leverages MS-CDC to gather and capture changes due to how logs are managed / not accessible from an Azure SQL DB database.

Pre-reqs for the MS-CDC connector can be found here - https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/SourcesConnections/AzureSQLMSCDC/Prereqs-sql-server-cdc.htm

Re: Prerequisite for Microsoft SQL Cloud

TimGarrod — Fri, 12 Jan 2024 14:02:16 GMT

FYI - this doc page provides the mapping of db 'type' to the connector to use - https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/SourcesConnections/supported-sources.htm

Re: Prerequisite for Microsoft SQL Cloud

harsh2 — Sat, 13 Jan 2024 19:51:11 GMT

Hello @TimGarrod ,

I sincerely appreciate your assistance. I would like to discuss AWS Microsoft SQL RDS for clearance.

Thank you,
Harsh