Q&A BY TAG 'PostgreSQL'

You must sign in to ask a question. If you do not have an account, you can register here

Connecting to Postgresql on EC2 Instance
answered 07-08-2020 04:00:19 -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: 1

PostgreSQL EC2 instance AWS

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

SSL I/O error PostgreSQL Informatica

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

external Database PostgreSQL MySQL

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

Denodo Express PostgreSQL Select Query

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

SolutionManager PostgreSQL

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

Data Destination Data Source PostgreSQL Data Movement

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

PostgreSQL oracle database connection

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

ODBC PostgreSQL Denodo with DB Visualizer

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

PostgreSQL Informatica