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)'
Hi Ldrees - Can you attach the Server and the Engine log files?
You can find the directories that have them in the ProgramData\Qlik\Sense\Logs\ directory
It may be a driver issue, permission issue or port issue on the EC2 box when attempting to retrieve the data. We may have to test this in house and troubleshoot.
Hi Ldrees - thanks. I forwarded the information appropriately. This issue may take a little longer to troubleshoot. I am working with the support team to see if we have a Redshift instance we can use. I can set one up if need be, but will need to work with our support team first.
Just for giggle - can you go to the local desktop of the EC2 instance and install another 3rd party software tool such as Microsoft Excel and use the same ODBC driver that you configured on that system with Excel to see if you can pull data without issue? This may be able to tell us something and possibly isolate if the issue is driver, port, permission related. Make sure you log in to the EC2 Desktop using the same account that is running the Qlik Sense services.
I am able to use the same ODBC driver for SQL Server and able to pull the data in qlik sense server. It is displaying the data in PREVIEW view and then allowing me to Load data set.
However, with redshift, though it does displays the data in preview view but unable to complete load data set operations.
Hi Ldrees - that is a good start,
Can you use another product such as Excel or some other tool on the same system as the Qlik Sense server with the Redshift ODBC driver (PostgreSQL ODBC) - you have setup? That way we eliminate Qlik Sense and focus on the ODBC driver and see if it pulls data into Excel without issue.