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.8KViews0likes11Comments
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.4KViews0likes3CommentsIssue 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 rdangi2@dxc.com1.8KViews0likes2Comments
Scheduled Build Not Building Table Changes
I have a scheduled build for my Elasticube each morning. The build behavior setting is set to "Replace All" on every table. When I make a change to a table the changes are not being built, new data is being imported but my new columns or where clause changes are not being applied. Also the table still has the triangle play button at the top left of the circle signaling that changes have been made. If I manually build with Replace All or Changes Only then the changes will be applied but I would like for the changes to be made each night when the Elasticube is pulling new data.Solved2.4KViews1like3Comments
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.4KViews0likes3CommentsChanging MySQL Connection String across all data models
My company is upgrading our MySQL version from 5.7 to 8.x. As such, it seems we must change the connection string in all our data connectors referencing the MySQL environment. Is there away of accomplishing this one-shot / globally rather than going into each individual ElastiCube / relevant data table and changing it piecemeal? (Most of our data models are ElastiCubes.) Many thanks!915Views0likes1CommentUnable to save configuration due to connection error with Application Database
Hi Support, I am unable to access the Sisense BI Webpage after a restart of the Windows server. I check the configuration manager and I cannot connect to the Application Database. Below is the error I get when I try to connect Unable to save configuration due to connection error with Application Database Error message: failed to connect to server [127.0.0.1:27018] on first connect [MongoError: connect ECONNREFUSED 127.0.0.1:27018]1.5KViews0likes1Comment
REST API: How to replace a datasecurity rule for live elasticube
Hi there, in https://sisense.dev/guides/restApi/v1/#/elasticubes/addDataContextForLiveElasticube for the dataContext you can read > If exact same shares array exits for table and column, then rule will be overwritten What exactly does "exact same shares array" mean? I retrieved all rules for a given data model with https://sisense.dev/guides/restApi/v1/#/elasticubes/getDataContextForLiveElasticube, then picked one rule and sent it to the POST route with changed members. I tried a shares array entry with and without partyName property when sending. The result was added rules instead of the existing rule replaced. Version: L2023.1.0.1841.6KViews0likes1Comment
Connection to BigQuery
Hi to all. I am a brand new Sisense user, never used before, and sorry if this question is too basic. I am trying to connect to our BigQuery database and I was reading that I need to copy as service account, therefore I will need the key .json file and, accordingly the documentation I need to copy this json file into the sisense server, is there a way to do this using the GUI interface instead copying physically into a folder on the sisense instalation path. Best Regards.1.4KViews0likes1Comment