topic Connect to SQL DB via (SQL VBO) to retrieve data into Collection in Product Forum

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

Hemanth_KumarRa — Thu, 07 Oct 2021 08:38:40 GMT

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

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

ewilson — Thu, 07 Oct 2021 15:29:22 GMT

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

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

gmarquez — Thu, 07 Oct 2021 15:34:45 GMT

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.