Cdata JDBC Drivers license
Hello everyone, I have a couple of questions that I hope you can help me with: 1) Does the Sisense Linux license provide us with free access to all cdata connectors, or do we have to purchase them separately? If we do need to purchase them separately, which licensing option should we choose from this page? 2) When troubleshooting issues with our custom connectors, how can I access the log files in the Sisense browser console/file manager? Do I need SSH access? Thank you.1.4KViews0likes3Comments
Issues trying to set up a data connector to SQL Server using server name
Hello I can connect to my SQL Server using the ip address but can't using the server name . I have added an entry to the etc/hosts file on the server (and restarted it), but I still cannot connect by server name. I can ping the server name on the Linux server. Any one got any ideas? Thanks1.2KViews1like2CommentsParquet - Sisense
Hello Community, We are exploring the possibility of using .parquet files in our Elasticubes. I would like to ask if anyone are using them in their Sisense deployment, and what is your experience when using them in terms of : - Implementation - Resources - Pros & Cons Any input would be very much appreciated!1.8KViews0likes3Comments
Issue with Elastic Cube Filed Fetching
Hello Sisense Support, I am writing to report an issue with one of our Elastic Cubes. When attempting to create a new dashboard using this Elastic Cube, the fields are not being fetched. Old dependent reports have data. I have attached screenshots for your reference, highlighting the problem. Additionally, there are no error messages displayed during the build process. This issue is hindering our ability to effectively use this particular Elastic Cube for reporting purposes. Your prompt attention to this matter would be greatly appreciated. Please let me know if there is any further information needed from my end. Sisense Version: L2023.9.0.271 Thank you, Rahul Dangi [email protected]1.8KViews0likes2Comments
Table Widget Format Header Row
Hello, I'm new to the Beta Community and a Java novice. Can a member direct me to internal Sisense sources on how to format a table widget's column header row and selected table columns (background color, font attributes, etc.)? Working in Linux environment, thanks - DennisSolved9.2KViews3likes6Comments
Is it possible to create a custom Python connector?
I was wondering if there's a way to create additional connectors using Python? We are able to create custom code Python scripts that can for example retrieve data from an API. This works great, but using the custom code approach has some problems: 1. Errors with the arguments passed to the script only appear when the cube is being build, instead of when adding the table to the cube. 2. There's no preview of the data being returned by the Python script. 3. We can pass passwords through as arguments, but the passwords are then visible to other users. 4. Only one table can be returned, instead of all the possible tables for a base endpoint. Of course we can use the Generic JDBC connector and the CData REST connector as well, however it would be nice to create connectors for the specific APIs we want to connect to, so that all the required input fields needed to set up the connection can be defined and seen right away, without having to put together a connection string for which the user has to download the CData driver. (Like we did in the attached image) Is there a way of creating a connector with Python? Or is it only possible by creating a JDBC driver?3.3KViews0likes3Comments
How to allow users to download a table with 300+ columns
I have been given a SQL query that has a column for each day of the year, and about 50 rows with different business metrics. I have also been told that I need to host this query in Sisense for users to download the data. Given the restrictions on table widgets, how should I best go about serving up this data? Currently, I have the query stored in an Elasticube as a table query. Our Sisense subscription also includes the Report Manager add-on. Thanks in advance for any help!Solved2.4KViews1like2Comments
Name Type Field Returned as { "Name": "Text" } instead of just Text
All of a sudden, all the name type fields/columns are now returned as { "Name": "John Doe") instead of John Doe. Data source is all from Salesforce tables. Is this a connector issue? It was ok before today. Thanks.869Views0likes1Comment
