Forum Discussion

swahla's avatar
swahla
Occasional Contributor
3 years ago
Solved

How can I connect to redshift in TestComplete

How can I connect to redshift in TestComplete

BDD Tests
Script Tests
web testing
  • JuZ0's avatar
    JuZ0
    2 years ago

    5.4.0 is quite old version. Here is some release history article: https://www.soapui.org/downloads/latest-release/release-history/

    It says for 5.4.0 following: ”SoapUI now uses Java 1.8.”. SoapUI 5.6.0 has following mention: ”Support for openJDK 12”

     

    So the switch from Oracle Java 8 implementation to OpenJDK happened in 5.6.0 version on 2020. 

     

    I think Oracle renewed its licensing politics after JDK 11 which lead many organizations to move to OpenJDK implementations.

     

6 Replies

Sort By
  • Marsha_R's avatar
    Marsha_R
    Icon for Champion Level 3 rankChampion Level 3
    3 years ago
    Copy LinkReport

    The only reference I can find is someone else asking the same question several years ago and there was no answer.

     

    mikef have you heard anything about this?

  • mikef's avatar
    mikef
    Icon for Staff rankStaff
    3 years ago
    Copy LinkReport

    Thanks Marsha_R 

     

    swahla TestComplete uses whatever ODBC drivers are available to it. Looks like you need to configure the ODBC driver for the Redshift instance. Once that driver/Data Link is available to TestComplete, you should be able to configure your connection string and use as a data source.

     

    NB : Setup the driver with the same "bitness" (32 or 64) as your TestComplete installation.

     

    Hope this helps

    Mike

    • swahla's avatar
      swahla
      Occasional Contributor
      3 years ago
      Copy LinkReport

      Marsha_R  mikef   Thank-you for pointing me in the right direction. I was able to connect after installing ODBC driver and building a connection string for a DSN-less direct connection to redshift mentioned in the shared link. I still have to try through secrets key.

      • swahla's avatar
        swahla
        Occasional Contributor
        3 years ago
        Copy LinkReport

        mikef  Any idea on how to set enable_case_sensitive_identifier to true after establishing a connection to redshift in testcomplete. Before executing a query in redshift editor we execute "SET enable_case_sensitive_identifier TO true" then it will consider the table and column names case sensitive. In testcomplete I am not able to do that and hence query always fails to find the tables I pass in queries and I get error "relation not found"