KAPOW

Would you like to react to this message? Create an account in a few clicks or log in to continue.
KAPOW

Welcome to the Kapow forum. Here you can get help, use your skills to help others and enjoy hanging out in the company of other Kapow Robot Developers.


    Execute SQL query

    victorg89
    avatar
    victorg89


    Posts : 10
    Points : 1835
    Join date : 2019-05-09
    • Post n°1

    Execute SQL query Empty Execute SQL query

    Post by victorg89 Tue Sep 17, 2019 12:27 am

    Hello,

    i need to run a SQL query, but i don't know where/how to configure the Database.

    my case: I use "SolarWinds Orion" to monitoring my environment, so i want to run a query at solarwinds database (SQL Server) to look wich servers are currently down and reboot then throught Kofax RPA.

    Is there any document where i can find how to configure the connection to other databases?

    Execute SQL query RYAAAAASUVORK5CYII=
    • Back to top
    victorg89
    avatar
    victorg89


    Posts : 10
    Points : 1835
    Join date : 2019-05-09
    • Post n°2

    Execute SQL query Empty Resolved

    Post by victorg89 Tue Sep 17, 2019 2:13 am

    RESOLVED - I uploaded de wrong JDBC driver, i was using mssql-jdbc-7.4.1.jre12 insted of mssql-jdbc-7.4.1.jre8

    And configured it correctly at Design Studio.

    Execute SQL query Wd4jP6TFwSaEQAAAABJRU5ErkJggg==

    https://knowledge.kofax.com/Robotic_Process_Automation/Configuration/Configure_Kapow_to_connect_to_a_Microsoft_SQL_Database_using_Windows_Authentication
    • Back to top
      Current date/time is Sun Apr 28, 2024 6:50 pm