Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create data connection to amazon Redshift using postgresql odbc driver (64 bit) in qlik sense server hosted on amazon EC2. Even though I am able to successfully establish connection, fetch table, prepare load statement with preview but when clicked on loaddata button to load the data, It throws an error
"Started loading data
Could not fetch connection by name using identifier PostgreSQL30 (qlikserver_virtusadmin) LIB CONNECT TO 'PostgreSQL30 (qlikserver_virtusadmin)'
"
Thanks
Idrees
Idrees,
I am using UNICODE too, and work perfectly for me. In that case, I need better detail what are you doing and step by step to reproduce. Again, Are you sure the within the Redshift VPC security group and the cluster security groups are set correctly and "qlikserver_virtusadmin" has full rights to the database.
Gio
Hi Gio
We are using the same account in performing the same operation of load data set for various types of data sources like SQL server, Excel file etc..So I think we might not have the rights issue here.
Thanks
Idrees
Hi,
Please find our observations as we continue to investigate and analyze the reasons behind ODBC driver not working properly with qlik sense server:
Thanks
Idrees
Idrees,
Thank you for the response, but again I am unable to replicate the issue, I am able to connect fine my Qlik Sense with Redshift database and load the data with my PostgreSQL. Now, what version you have installed?
I am using 9.03.02.10.
Gio
Hi gio,
I am using qlik sense server version of 1.0.1.
Also, can you please share your steps and process in details in connecting with Redshift. I would like to execute exactly same steps at my end to make it working.
Thanks
Idrees
Hi Gio,
can you please confirm that you are using qlik sense server version 9.03.02.10. If this is correct, then it seems we are using much older version of qlik sense server version 1.0.1 and we would like to work with sales team of qlik sense in getting the latest version updates so we can do integration and evaluate.
Thanks
Idrees
Idrees,
Mmmm, I do not think Qlik Sense version 9.03.02.10 ever existed, what I meant I have PostgreSQL ODBC driver version 9.03.02.10. The only 3 public versions of Qlik Sense were .96, 1.0 and 1.0.1, which I had tested in Qlik Sense 1.0 and 1.0.1 and all works fine. On my last post I requested to check you PostgreSQL ODBC driver version.
Gio