topic RE: How to connect to different databases in BluePrism apart from Local DB in Product Forum

How to connect to different databases in BluePrism apart from Local DB

satishreddy2 — Thu, 20 Feb 2020 05:24:00 GMT

I am using Blue Prism ver-6.5 and now i need to connect to different data bases from different machines ( [1]. Blue Prism local data base installed in another system, [2]. IBM DB2 installed in another windows machine - i am able to connect to IBM DB2 data base by installing DB2 client in my machine and fetching data by using OLEDB vbo but my requirement was fetching data from db without installing client).

Please let me know if anyone of you are aware of this.

------------------------------
Satish Reddy.
------------------------------

RE: How to connect to different databases in BluePrism apart from Local DB

GopalBhaire — Thu, 20 Feb 2020 12:42:00 GMT

Are you able to connect to SQL server of machine on which Blue Prism Database is hosted, if yes you can use SQL Server VBO to connect to that DB.
For IBM DB2 you'll at least require installation of OLEDB Drivers for connecting to it using OLEDB VBO

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: How to connect to different databases in BluePrism apart from Local DB

satishreddy2 — Fri, 21 Feb 2020 05:12:00 GMT

I can connect to SQL server of machine on which Blue Prism Database is hosted, it's fine but i need to connect to database (SQL server of machine on which Blue Prism Database is hosted) in another machine

------------------------------
satish reddy
------------------------------

RE: How to connect to different databases in BluePrism apart from Local DB

chris.strong — Fri, 21 Feb 2020 09:54:00 GMT

Hello Satish,

The Help page How do I configure a SQL server connection and database in Blue Prism? Provides detailed guidance on setting up a database connection.

Tip:

To connect to a database on another Database Server, typically this would be in the format ServerName\DatabaseInstanceName and the Database Name is the name of the Blue Prism database within the instance.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------

RE: How to connect to different databases in BluePrism apart from Local DB

satishreddy2 — Fri, 21 Feb 2020 10:08:00 GMT

PFA

------Original Message------

Hello Satish,

The Help page How do I configure a SQL server connection and database in Blue Prism? Provides detailed guidance on setting up a database connection.

Tip:

To connect to a database on another Database Server, typically this would be in the format ServerName\DatabaseInstanceName and the Database Name is the name of the Blue Prism database within the instance.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------

RE: How to connect to different databases in BluePrism apart from Local DB

chris.strong — Fri, 21 Feb 2020 11:09:00 GMT

Hello Satish,

OK, two things:

If you are a customer or partner, you can email the support team (support@blueprism.com) to uplift your permissions for the Blue Prism Portal. This will then allow you to view the support and training materials.
Main things from the Help page are below:

Configure a connection to the SQL server instance

To define a connection to the SQL Server instance where the database is, or will be, hosted, perform the following steps:

Click Configure. This will launch the wizard that can be used to provide the connection information.
Specify the name for this connection, and the settings required to connect to the SQL Server instance.

The name of the intended database will also be specified on this screen. This is the name that will be used to create a new database; or it can be the name of an existing database.
*If the Connection type applies Windows Authentication, the context of the user currently logged into the device will be used to authenticate against the SQL Server. Where possible Windows Authentication (rather than SQL Authentication) should be used.
** Can be left blank. Populate if there is a requirement to add custom SQL Connection Parameters such as: encrypt=true; trustservercertificate=true.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------