I have used postgresql to connect the denodo, And these are the connection properties ;
Name : test
DB adapter : PostgreSQL 10
Driver class path: PostgreSQL-10
Driver class : org.postgresql.Driver
Databae URI: jdbc:postgresql://localhost:5432/test
Transaction isolation: Database default
authentication: use login and password
login : (postgresql username)
password; (postgresql password)
My Denodo Database structure :
admin(Database)
|
|
*******PostgreSql(folder)
|
|
********test(postgres database)
car (table)
test_proc (table)
This is the code that I'm using to connect denodo platform :
string query = "SELECT * FROM car";
string connectionString = "Server=localhost;Port=9996;Username=admin;Password=admin;Database=admin/test;Timeout=300;CommandTimeout=300";
try
{
using (NpgsqlConnection connection = new NpgsqlConnection(connectionString))
{
connection.Open();
using (NpgsqlCommand command = new NpgsqlCommand(query, connection))
{
HandleReader(command, maxRows);
}
}
}
catch(exception ex)
{
console.writeline(ex.message);
}
When I open the connection it shows an exception that shown below,
When I use - database:admin
" Received unexpected backend message ParseComplete. Please file a bug."
When I use - database:test
" : authentication error: Database 'test' not found"
What Could be the issue?
How to connect denodo db with connection string?
is that need to use encryption?
Could you please help me to undestand what is wrong in the above code?
