Q&A

oracle-SQl developer connection
answered 07-02-2019 00:21:05 -0500

Is it possible to connect to denodo from Oracle-sql developer? If yes. how ?

Answers: 1

#Oracle

Cached view using statistics in the query execution
answered 06-02-2019 05:50:23 -0500

Hi, we are using denodo 6 with cache db as Oracle. we want to explore collecting statistics for the cached views brought in from the other data sources. Is there a way to check if we execute a query on the cached view that those statistics are being u...

Answers: 1

Does SAP HANA can conned Denodo through API's rather than JDBC souce?
answered 05-02-2019 12:17:40 -0500

Hi, Can we connect SAP HANA through SDI API's provided? If so, which source we need to use while creating Data Source. Thanks,

Answers: 1

DENODO

How Code injection is handled in Denodo?
answered 05-02-2019 05:39:21 -0500

I have created a base view using SQL Server table. There is a column called "Tag" in the SQL table. The DATA REST API is created using the same base view. This tag column in nothing but a search parameter which will be passed from the web client. How...

Answers: 1

denodo security code injection sql injection

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