Denodo community Q&A RSS feed https://community.denodo.com/answers//feed/rss Latest Denodo community questions LEAD function doesn't work in Denodo 8 https://community.denodo.com/answers/question/details?questionId=906Qj00000AyOZZIA3&title=LEAD+function+doesn%27t+work+in+Denodo+8 Hi there, when I tried to use LEAD function in Denodo 8, the color doesn't change and the error shows the Function LEAD is not executable. From the documentation, the LEAD function is available in Denodo. What I have missed? Thank you! Wed, 17 Apr 2024 21:02:14 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AyOZZIA3&title=LEAD+function+doesn%27t+work+in+Denodo+8 2024-04-17T21:02:14Z Connecting to VDP with EF/ADO.Net https://community.denodo.com/answers/question/details?questionId=906Qj00000AxRuVIAV&title=Connecting+to+VDP+with+EF%2FADO.Net Hi, We want to use Entity Framework to connect to Denodo VDP Server. The documentation at https://community.denodo.com/docs/html/browse/latest/en/vdp/developer/access_through_an_ado.net_data_provider/access_through_an_ado.net_data_provider shows that a only a very old version of the driver is supported. Could you let me know what the latest version to use with Denodo Platform 8? Thanks! Wed, 17 Apr 2024 17:12:53 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AxRuVIAV&title=Connecting+to+VDP+with+EF%2FADO.Net 2024-04-17T17:12:53Z ORACLE TO VQL https://community.denodo.com/answers/question/details?questionId=906Qj00000AwivmIAB&title=ORACLE+TO+VQL I need to converter this TO_CHAR(9999, 'fm00000') for a vql. Is that possible? Thank you. Regards Wed, 17 Apr 2024 13:54:53 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AwivmIAB&title=ORACLE+TO+VQL 2024-04-17T13:54:53Z MongoDB Atlas (through AWS) https://community.denodo.com/answers/question/details?questionId=906Qj00000AvsYzIAJ&title=MongoDB+Atlas+%28through+AWS%29 Hello, I'm trying to connect a MongoDB Atlas cluster from Denodo through the mongodb-customwrapper. Reading the user manual about this custom wrapper, it seems to me that ony clusters "based" on Azure can connect to Denodo. It is correct? I'm using a cluster "based" on AWS and I can't connect with this custom wrapper.. there is a way to connect thi AWS based cluster on MongoDB Atlas from Denodo? Am I missing something? Thanks, Maria B. Wed, 17 Apr 2024 08:20:05 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AvsYzIAJ&title=MongoDB+Atlas+%28through+AWS%29 2024-04-17T08:20:05Z require guidance on creating new views in Denodo https://community.denodo.com/answers/question/details?questionId=906Qj00000AnytJIAR&title=require+guidance+on+creating+new+views+in+Denodo require guidance on creating new views in Denodo. We are aggregating data from old and new version of RAMOS (basically from two databases) into one source domain and building views on top of that for our downstream systems to consume. Can you suggest the right approach and what all do we need to do in order to achieve this business objective? Mon, 15 Apr 2024 08:19:13 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AnytJIAR&title=require+guidance+on+creating+new+views+in+Denodo 2024-04-15T08:19:13Z first of current year https://community.denodo.com/answers/question/details?questionId=906Qj00000AiqtBIAR&title=first+of+current+year how do I pull first of current year and forward? for example, when the date is currently 1/1/24 to 12/31/24, I always want to get results from 1/1/2024 and forward. Fri, 12 Apr 2024 17:41:24 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AiqtBIAR&title=first+of+current+year 2024-04-12T17:41:24Z remote table https://community.denodo.com/answers/question/details?questionId=906Qj00000AdgmPIAR&title=remote+table https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/remote_tables/remote_tables Question 1: does Denodo express 8.0 has this remote table feature. Question 2: in licensed version of Denodo 8.0, can remote table fetaure write data to AWS S3 bucket. Question 3: in licensed version of Denodo 8.0, can remote table write back data to a DB for any view (base view , derived view). or there is any limitation. note: URGENT. please answer. Thanks. Thu, 11 Apr 2024 11:55:31 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AdgmPIAR&title=remote+table 2024-04-11T11:55:31Z Unexpected error creating a connection https://community.denodo.com/answers/question/details?questionId=906Qj00000AdDAvIAN&title=Unexpected+error+creating+a+connection hi team, When attempting to connect to the data source, we encountered an error. Could you please advise on the potential issue and provide a solution? Unexpected error creating a connection: Failed to authenticate the user ctris-prod.rps-co-sqldw@gsk.com in Active Directory (Authentication=ActiveDirectoryPassword). Thnak you. Thu, 11 Apr 2024 07:37:36 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AdDAvIAN&title=Unexpected+error+creating+a+connection 2024-04-11T07:37:36Z How to deal with BLOB in Denodo? https://community.denodo.com/answers/question/details?questionId=906Qj00000AcrbpIAB&title=How+to+deal+with+BLOB+in+Denodo%3F Hello Team, I have a situation that I imported a base view from SAP table. But there is a column which data type is RAW in SAP. After creating base view in Denodo, the type of such column convert to BLOB. If I use cast('text',column) when creating derived view based on the base view, the result of such column is garbled. Does the issue come from decoding? Should I complete any special configurations to restrict charset when creating data source? How can I convert such BLOB to a text in order to use the column to join with other views? And in which layer I should convert the data type? Thanks. Thu, 11 Apr 2024 03:07:28 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AcrbpIAB&title=How+to+deal+with+BLOB+in+Denodo%3F 2024-04-11T03:07:28Z Allow logging all received requests in the Scheduler REST API. https://community.denodo.com/answers/question/details?questionId=906Qj00000AbJVmIAN&title=Allow+logging+all+received+requests+in+the+Scheduler+REST+API. As mentioned in the enhancementâ?¯#78114, we can now add logger to all received requests in the Scheduler Rest API. How can we configure this functionality ? And for the logs, are they stored in files ? Thanks Wed, 10 Apr 2024 18:22:27 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AbJVmIAN&title=Allow+logging+all+received+requests+in+the+Scheduler+REST+API. 2024-04-10T18:22:27Z