Forum Discussion

swahla's avatar
swahla
Occasional Contributor
3 years ago

How can I connect to redshift in TestComplete

How can I connect to redshift in TestComplete
BDD Tests
Script Tests
web testing
  • mikef's avatar
    mikef
    3 years ago

    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

mikef's avatar
mikef
Staff
3 years ago

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

    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
      2 years ago

      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"