Connecting to Clickhouse
I was recently speaking with Kat about certified connectors and related status for those connectors – specifically related to Clickhouse, which is listed as a Certified data connector for Sisense. Are there any Sisense customers out there that are using Clickhouse successfully with Sisense? To us, "successfully" would at a minimum include: Being able to connect using a Live Connection for interactive query and aggregation via Sisense Notebooks Being able to load data from Clickhouse into Elasticubes Thanks all!5.7KViews0likes11Comments
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
Error querying data model and X509 certificate has expired or is not yet valid
Hi, All the dashboards in our Sisense server are not working today with the Error "Error querying your data model"! We double checked that our database server is up running... When I tried to log into the Sisense CLI on the Sisense server, I got the following error message. Could you help check what is wrong? [ec2-user@node1 ~]$ source add_completion-ns-sisense.sh Loading kubectl completion ... Loading helm completion ... Context "kubernetes-admin@cluster. local" modified. Now you can use 'k' alias for querying Sisense Kubernetes resources (Example: k get nodes) ... Unable to connect to the server: x509: certificate has expired or is not yet valid: current time 2023-01-05T20:02:43Z is after 2022-07-12T17:27:33Z Unable to connect to the server: x509: certificate has expired or is not yet valid: current time 2023-01-05T20:02:43Z is after 2022-07-12T17:27:33Z Unable to connect to the server: x509: certificate has expired or is not yet valid: current time 2023-01-05T20:02:43Z is after 2022-07-12T17:27:33Z error: pod, type/name or --filename must be specified Using Sisense address to login to Sisense CLI ... -bash: login_sisense: command not found1.5KViews0likes1Comment
Sharepoint Excel Services JDBC Driver
I'm trying to create a connection between Sharepoint and Sisense. However, when I try to create the connection string using the Excel Services JDBC Driver I get 'HTTP protocol error. 403 forbidden'. I'm not sure what the fix here should be. Can anyone assist?1.8KViews0likes1Comment
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
Bigquery can't retrieve data but can see schema due to wrong dataset location
I can retrieve all datasets and tables from Bigquery but when trying to actually get the data (preview or executing custom sql). It happens for Live connection and Elasticube. I use a json service account file to authenticate and withing Google Cloud logging I see that Sisense is trying to fetch the data from US which is not the location the dataset is. I don't know how to fix it. Google cloud log: when trying to fetch data: "Not found: Dataset PROJECT_XX:dataset_xx was not found in location US"1.3KViews0likes3Comments
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
