QlikReplicate to connect the Google Bigquery

[srikar22]

I am trying to connect to google BQ I am successfully able to create ODBC connection but not from qlikreplicate getting this error

SYS-E-HTTPFAIL, Cannot connect to ODBC provider.
SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: 08001 NativeError: 10380 Message: [Simba][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[KeyFilePath_Enc]}
 

[john_wang]

Hello @srikar22 ,

Thanks for reaching out to Qlik Community!

Not very sure what's the Replicate Server platform however you may try to create a 64-bit ODBC DSN and test the connectivity by using isql on Linux, any 3rd party ODBC Test Tools on Windows to troubleshoot the issue.

Hope this helps.

John.

[sureshkumar]

Hello @srikar22 
What is the Qlik Replicate Version?
Please make sure you've installed correct ODBC version as per the user guide.

Regards,

Suresh

[SushilKumar]

Hello @srikar22 

refer below Section seems you did not put the key.

Setting general connection properties | Qlik Replicate Help

regards,
Sushil Kumar

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

[andresa7]

How much data are you trying to drag through? More than sheets can handle? Or can you just pull all through?

SQL is quite intuitive when you keep it simple.