Q&A

SQL performance
answered 05-02-2019 04:17:58 -0500

Does Denodo query runs faster than oracle? I have a simple one base table ( source oracle), it runs slower than oracle!!! any clues ?

Answers: 1

#salesforce #performance #optimization

StorageInternalException
answered 04-02-2019 06:22:44 -0500

Getting these error so oftenly and then denodo server get hang and not responding "Caused by: com.denodo.vdb.catalog.storage.StorageInternalException: Error accessing the metadata while loading/storing objects at com.denodo.vdb.catalog.storage.DBDerby...

Answers: 1

derby Error

License for personal developer
answered 04-02-2019 06:18:27 -0500

We don't want to register every laptop that is going to be developing. Is there another way? We tried copying the main license file to the local laptop and use that and there's an error.

Answers: 1

License

Create Wrapper through Store procedre
answered 01-02-2019 06:43:40 -0500

Hi Team,, I am trying to create a wrapper through Java Store procedure and below is the code. String query2 = " CREATE OR REPLACE WRAPPER JDBC test_select " + " FOLDER = '/data sources' "+ " DATASOURCENAME=denodo_5_5_copy " + " SQLSENTENCE='DESC VQL ...

Answers: 1

Display column description INSTEAD of column name
answered 01-02-2019 04:33:15 -0500

When building views for our business I want to display COLUMN_DESCRIPTION not column names in my views and reports. How can I display COLUMN_DESCRIPTION instead of COLUMN_NAMES in views derived from iv_views?

Answers: 1

COLUMN_DESCRIPTION

Store procedure "Query not Supported"
answered 01-02-2019 04:30:47 -0500

Hi Team, I am trying to write a store procedure using java to extract VQL of multiple views. Below is the code i have written. But after exceution it's showing " Query not supported" error. Could you guys please look into my code and tell me where i...

Answers: 1

How to configure Denodo Expess Server with Power BI Services by using gateway
answered 31-01-2019 22:19:34 -0500

Hi, I have Denodo Express Server installed on one Azure Virtual Server. I managed to configure Denodo Power BI Custom Connector on the same virtual server. Power BI Desktop works fine, but I am not able to read data on reports I´ve published into Powe...

Answers: 4

DESC VQL Datasource JDBC
answered 31-01-2019 14:37:39 -0500

Beside DESC command, is there a way to query JDBC datasource's DATABASEURI and username for all JDBC on a production environment? thanks

Answers: 1

DESC

Recommendations on ways to provide HA or Fault Tolerance for the License Manager.
answered 31-01-2019 13:02:25 -0500

Looking for any suggestions or resources on how to provide fault tolerance for the License Manager

Answers: 1

License File HA Fault Tolerance

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