Connect to SQL DB via (SQL VBO) to retrieve data into Collection

[Hemanth_KumarRa]

Hi Everyone, 

I need to connect to SQL DB to retrieve some data into collecton.
I request the community to help me in forming the connection to SQL-DB via native SQL VBO.

I have (DB Name, IP address, UserName, Password) data.
Please suggest me how do I need to proceed for setting connection?



Regards,
Hemanth Kumar

[ewilson]

Hi @Hemanth_KumarRa,

Have you tried setting the values as:

• Server = IP address
• Database = DB Name
• User = UserName
• Password = Password

You may need to include the port number (1433 is the default I believe) with the IP address.

Cheers,
Eric​​

[gmarquez]

Hi Hemanth,

The connection string will be built in the process after you fill in the blanks with the information. You need to know if you are using SQL or Windows authentication for the string. Here is an excerpt from the VBO help:

I hope that helps.