May 20, 2021 at 12:55 PM

Azure SQL DB connection/integration with BODS

480 Views

Hi Experts

Problem: Connection timeout.

Trying to connect the Azure DB from DS by configuring Data Store like below. On first connection attempt to DB from DS, after 30 seconds I get below error message but the job is successful, second attempt and subsequent attempts are always successful and could extract/load data accordingly, I understand the error is happening due Azure DB is on sleep mode on first attempt.

I have checked other questions but could not resolve my issue.

DS Version: SP07

MS SQL Server 2014.

Please guide me with right config or suggest the steps to resolve this issue

ODBC Driver Issue ?
Connection timeout to increase on Azure DB ?

Error Msg in DS:

ODBC Driver used are:

Configured using these drivers, but both failed in first attempt

Data Store in DS:

Error:

ODBC call <SQLDriverConnect> to connect database <DS_XXX_INT> failed with error: <ODBC call <SQLDriverConnect> for data source <DS_XXX_INT> failed: <[Microsoft][SQL Server Native Client 11.0]TCP Provider: Timeout error [258]. [Microsoft][SQL Server Native Client 11.0]Unable to complete login process due to delay in login response [Microsoft][SQL Server Native Client 11.0]Login timeout expired>

Thanks

Uday

Attachments

error-msg.png (17.0 kB)

odbc-drivers.png (4.6 kB)

ds-in-bods.png (6.2 kB)