Connect to SQL DB via (SQL VBO) to retrieve data into Collection
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-10-21 09:38 AM
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
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-10-21 04:29 PM
Hi @Hemanth_KumarRa,
Have you tried setting the values as:
Cheers,
Eric
Have you tried setting the values as:
- Server = IP address
- Database = DB Name
- User = UserName
- Password = Password
Cheers,
Eric
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-10-21 04:34 PM
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.
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.
