Azure SQL DB connection/integration with BODS

[former_member693208]

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

[former_member750979]

Hi Udaya,

Did you get any solution for this, even I have a similar requirement to connect the Azure SQL Database and experiencing similar issue.

Any update on this it would be great help if you can share with us.

--Bhaktha.

[omkarsambare]

I don't think ODBC Driver 17 for SQL Server is supported with the DS 4.2 SP 7 and MS SQL Server2014. Check the DS PAM guide for the same, this could be the issue itself.