Data loading to Azure DB

dataservices job design
1

Hi,

Can anyone please guide how to load data to Azure DB cloud (SQL server) from BODS4.2?

thanks

DbUoRdAsI :india: (BOB member since 2012-05-08)

2

Hi all,

I am trying to load data to Azure cloud SQL server DB, I was able to create datastore, but while running the job I am getting the below error.

ODBC call <> to connect database
failed with error: <>. Use the ODBCDriverSelector
(Windows) or DSConnectionManager.sh (UNIX) utility in
LINK_DIR/bin to configure the correct version of the driver. If the
problem still exists after selecting the correct
version of the driver, notify Customer Support.

Can someone help me to fix the issue?

DS version : 4.2 SP7

DbUoRdAsI :india: (BOB member since 2012-05-08)

3

You need to have the permissions updated on your account so you can see the error message.

  • E

eepjr24 :us: (BOB member since 2005-09-16)

4

Hi,

I am facing the same issue while connecting to a SQL DB on Azure VM. Are you able to resolve this issue ? Can you please update the latest on this ?

Thanks.

Karthik23 (BOB member since 2018-06-05)