Skip to main content
Nintex Community Menu Bar

Integrating with RDS databases

  • November 5, 2019
  • 2 replies
  • 157 views
  • Translate
D

I realize that RDS isn't supported by K2, but I'd be very grateful if anyone can share any real experiences connecting to RDS. We don't want to use it for our K2 database, but some of the systems we integrate with want to move to RDS.

 

Here is what I've found with my initial attempts. I connected to an RDS database and used the SMO tester:

 

  • I can call create, list, and delete on SMOs that are directly against tables
  • I was able to call a database view and view results.
  • I called 2 stored procs. One of them returned data and one didn't. I can't tell why the one didn't.

Any experiences with RDS would be very helpful to me.

    Did this topic help you find an answer to your question?

    2 replies

    K
    Nintex Employee
    • katlehonNintex Employee
    • Nintex Employee
    • 79 replies
    • November 6, 2019

    Hello Dustinaleksiuk,


     


    Yes, RDS integration is not supported by K2, but it does not mean that it wont work with K2. It only means that K2 has not performed any rigorous testing on integration with RDS.


     


    I know that I am not sharing an experience with RDS in terms of integrating it with K2, but I just thought of putting this out as reference to your experience.


     


    Regards,


    Katleho

    Translate
    D
    • Dumisani
    • 151 replies
    • November 6, 2019

    Good day   @dustinaleksiuk


     


    As "Katlehon" has mentioned we do not officially support Amazon RDS. We only support "pure" Microsoft SQL Server or Azure SQL as reflected in compatibility matrix:


    https://help.k2.com/k2compatibilitysupportmatrix#SQLServer


    Officially it is not supported at the moment and we have feature requests logged for that, however, you can also create your own feature request at https://ideas.k2.com/  


    So that it can be motivated and be released on the upcoming future releases of the product.


    From the technical standpoint Amazon RDS should expose SQL DB with DB owner rights, but with limited/no server level rights (DB as a service) - so installation should be performed the same way as for Azure SQL. K2 installer wants to have SQL server level rights (db_creator, security_admin) to create K2 DB and assign rights on it. In DB as a service scenario, you may not have all these rights, so for Azure we using DAC package to pre-create K2 DB, see details here: https://help.k2.com/onlinehelp/k2blackpearl/icg/4.7/default.htm#Install/AzureSQL/AzureSQL_BP.htm#Create


    If Amazon RDS was supported, then installation process would most likely be similar to Azure SQL installation scenario. But this is not something we have official support for at the moment.


     


    Kind regards,


    Dumisani


     

    Translate

    Reply


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie Settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie Settings