Connect Snowflake DB to TestComplete
How can we execute query through snowflake on testcomplete using javascript and verify the data in testcomplete itself?
Forum Discussion
Hi,
Access to database data in TestComplete uses the same approach for any database.
Primary option is ADO-based (Access Data Objects in the form of either native ADO COM objects or ADO Support extension provided by TestComplete. The latter is just a wrapper around native ADO). ADO requires either database-specific OE DB provider or ODBC driver. The bitness of OLE DB provider or ODBC driver must match TestComplete's bitness (or vise versa) and not necessarily must match the bitness of the database engine,
To use this option you must find either OLE DB provider or ODBC driver for Snowflake and then follow https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/databases/index.html help section.
Secondary option is when/if the database does not provide any OLE DB/ODBC access but instead provides some DLL that makes it possible to access database data. In this case one can access database data by utilizing this DLL as per https://support.smartbear.com/testcomplete/docs/testing-with/advanced/using-external-functions/calling-from-dll/index.html help section.
