Capture

 View Only
last person joined: 16 days ago 

A community for Blue Prism Capture

  • 1.  Blue Prism Connection to HANA Database

    Posted 03-23-2022 17:30
    Hi All,

    In my current project we have a requirement to connect the HANA DB and run the select query and capture the result. Can you please guide me how to complete this connection setup.

    ------------------------------
    Vikash Anand
    Application Development Team Lead
    Accenture
    ------------------------------


  • 2.  RE: Blue Prism Connection to HANA Database

    Posted 03-23-2022 18:47
    Hi,

    I look for an Asset in the Digital Exchange platform and I didn't found the connector.

    If you are familiarized with C#, here you have a full guide of to connect directly with SAP HANA Data Base

    https://www.kodyaz.com/visual-studio/connect-to-sap-hana-database-using-odbc-sample-code.aspx

    Unfortunately I don't have an instance of this kind of data base to test this in detail, sorry :(


    Hope this helps you!

    See you in the community, bye :)

    ------------------------------
    Pablo Sarabia
    Architect
    Altamira Assets Management
    Madrid
    ------------------------------



  • 3.  RE: Blue Prism Connection to HANA Database

    Posted 03-24-2022 10:11
    @Pablo Sarabia Thanks for the link provided. Will explore this above option.​

    ------------------------------
    Vikash Anand
    Application Development Team Lead
    Accenture
    ------------------------------



  • 4.  RE: Blue Prism Connection to HANA Database

    Posted 09-20-2022 20:52
    hi Vikash,

    Can you please share the steps to connect Bluerprism with HANA DB.
    Also please help with additional driver we need to install.
    This would be of a great help.

    Thanks

    ------------------------------
    Bhanu Challa
    ------------------------------



  • 5.  RE: Blue Prism Connection to HANA Database

    Posted 09-22-2022 10:09
    Hi Bhanu,

    We were able to set the connection between HANA and BP by following below steps.

    First step was to install the HANA Application. This package usually will include the HANA ODBC drivers as well.
    Read : https://www.kodyaz.com/visual-studio/connect-to-sap-hana-database-using-odbc-sample-code.aspx

    Once the Studio, Client and the HANA ODBC Drivers are installed we can go ahead and try to establish the connection to the HANA DB.

    We were able to establish connection to the HANA DB using Powershell Script.

    This below code will establish a connection and a query is passed where we are getting the data from a sample DB and the output is saved as a txt file.


    $conn = new-object System.Data.Odbc.OdbcConnection

    $conn.connectionstring = "DSN=HDBODBC;UID=USERNAME;PWD=PASSWORD;SERVERNODE=abcxxxxx.xx.xx.xxxxx.com:xxxxx;DATABASENAME=DataBaseNAME"

    $conn.Open()

    $result =(new-Object Data.Odbc.OdbcCommand("select * from DATA_TYPES",$conn)).ExecuteReader()

    $table = new-object "System.Data.DataTable"

    $table.Load($result)

    $table | Out-File C:\RPA\output.txt

    $conn.close()

    Hope this help you!

    Thanks,
    Vikash

    ------------------------------
    Vikash Anand
    Application Development Team Lead
    Accenture
    ------------------------------



  • 6.  RE: Blue Prism Connection to HANA Database

    Posted 09-23-2022 01:32
    Great!
    Happy to hear that.

    ------------------------------
    Bohyon Hwang
    Director
    블루프리즘
    Seoul
    +82262033950
    ------------------------------



  • 7.  RE: Blue Prism Connection to HANA Database

    Posted 09-21-2022 01:48
    That's a good information.
    The SAP HANA database also supports ODBC connections.
    Consequently, Blue Prism seems to be able to connect using the Connector for ODBC Utility.
    The imported VBO name is Data - ODBC.
    However, the system setup process may be complicated because the proprietary HDBODBC driver needs to be installed first.

    ------------------------------
    Bohyon Hwang
    Director
    블루프리즘
    Seoul
    +82262033950
    ------------------------------



  • 8.  RE: Blue Prism Connection to HANA Database

    Posted 12-14-2022 15:35
    Hi Bohyon, 
    While calling it from Blueprism getting exception - Something threw an exception
    Exception calling "Open" with "0" argument(s): "ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application".   Eventually Bluepirsm is 32 BIT, wheres the driver and the HANA DB is 64 BIT. Any idea how to resolve this.  
    Thanks in advance.

    ------------------------------
    Deepti Gupta
    Application Developer
    IBM
    UTC
    ------------------------------



  • 9.  RE: Blue Prism Connection to HANA Database

    Posted 12-15-2022 00:36
    There might be a driver named as HDBODBC32, which should support 32-bit mode.


    ------------------------------
    Bohyon Hwang
    Director
    블루프리즘
    Seoul
    +82262033950
    ------------------------------



Welcome to the Capture Community!

Blue Prism Capture is an intelligent process capture platform that simplifies the creation of process definition documents (PDDs) by combining task extraction and computer vision to auto-generate screenshots, step descriptions, process data, and process flows from a process owner demonstration. Customers can then optimize the process by adding or modifying steps and then extract their completed PDD, more quickly and accurately, into their preferred file format, including a Blue Prism process outline, which reduces time to automation even further.

Capture Product PageCapture HelpCapture FAQs

FAQs

Blue Prism Capture is an on-premise solution that combines task extraction and computer vision to auto generate screenshots, step descriptions, process data, and process flows, from a process owner demonstration of the as-is process. The captured flow can then be viewed and optimized by a process analyst, who can add further notes, definitions, and rearrange the steps in the flow, to produce a Process Definition Document (PDD) ready to be used by developers. Capture is free to use at the initial general release, with additional capabilities such as export to Blue Prism processes being developed in future releases.
Capture v3.0 is available at no extra costs to all Blue Prism customers, with the software available to download on the Blue Prism Product Portal.
Capture v4.0 is available at no extra costs to all Blue Prism customers, with the software available to download on the Blue Prism Product Portal.
The known issues list for Blue Prism Capture can be found here.
Blue Prism Capture is free to use at the initial general release, with additional capabilities such as export to Blue Prism processes being developed in future releases. It is currently available to all Blue Prism Customers, with the software available for download on the Blue Prism Product Portal.