Q&A BY TAG 'POSTGRESQL'
Connecting to Postgresql on EC2 Instance
answered
07-08-2020 11:59:40 -0400
Hi, I am trying to connect to a database "user" on a PostgresQL I set up on an EC2 instance. I believe I have allowed port 5432 on the inbound rules and I have modified the two config files. But I received this error message. Unable to establish c...
Answers:
2
ERROR: Syntax Error: Exception Parsing query near 'show'
answered
24-09-2019 08:13:43 -0400
Hi, I am trying to get my odbc 64 bit connection working on my pc. my 32 bit works fine. For this 64 bit I am using PostgreSQL Unicode(x64). I have the same settings as my odbc32. Except the postgresql versions are different. 32odbc i run ANSI 9.03...
Answers:
1
Getting SSL I/O errors while loading data from Denodo views using Informatica sessions
answered
14-06-2019 02:16:17 -0400
I am getting few SSL I/O errors in the Informatica session when I try to load data from Denodo view. The issue seems to go away when I try restart the failed session, but seeing this issue quite often. Do I need to make any configuration changes on De...
Answers:
3
Access to Derived Views from Mysql or Postgres
answered
02-04-2019 08:18:09 -0400
I have created some derived views and I need to read the data from those views and process the data and save it in an external database (Mysql, postbres), in a custom table. How you could do that? Or is possible to publish the information that I get fr...
Answers:
1
Create Base view from SQL query
answered
15-02-2019 07:24:08 -0500
Hello there! I'm tottaly new on Data Virtualization and Denodo I'm trying to create my first view from SQL query (PostgresSQL) Would you guys could help me o that? <image src="https://drive.google.com/open?id=0B5D_BLEYhiEMU2lXNmZXY09CUHRpM3R0VVNx...
Answers:
1
SSL connection from PostgreSQL to Denodo 7 Solution Manager metadata
answered
31-01-2019 07:23:15 -0500
I have installed Denodo 7 Solution Manager with a postgresql db for the Solution Manager metadata which worked just fine but now I need to SSL the connection using certificates. I have the my server.crt, server.key and ca_bundle.crt in the data directo...
Answers:
1
PostgreSQL Data Movement Error
answered
19-04-2018 01:44:24 -0400
At present, I’m consuming data from a PostgresDB and looking to write to another PostgresDB using the below statement, however it returns an error stating the ‘Virtual Data Port does not support data movements to data source’ and lists a number of supp...
Answers:
2
Error connecting Denodo to a PostgreSQL and Oracle database
answered
18-10-2017 10:41:19 -0400
I am trying to connect to a PostgreSQL 9 and an Oracle 11g database using Denodo but i get the following errors: https://imgur.com/a/igQma i already installed the latest version of java and of the jdbc drivers but still i get these two errors, does any...
Answers:
2
Getting "Communication closed during authentication; Socket has been closed" error while creating User DSN using PostgreSQL ODBC Driver
answered
05-01-2016 14:49:56 -0500
I have created a virtual table using denodo virtualization tool. Now to access this table from my application I am creating ODBC connection. But during DSN creation when I am testing the connection it throws error "Communication closed during authentic...
Answers:
1
Not able to import Denodo views as Data Source in Informatica Designer
answered
18-08-2015 14:01:27 -0400
I am not able to import Denodo views as data source in Informatica Designer. Have installed Postgre SQL ODBC driver 9.03.0300. I am able to login to Denodo database via the ODBC connector; but the Designer crashes every time when I try to select a Deno...
Answers:
1