This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
Introduction This forum post will demonstrate how to add data located in a shared network folder to your desired ElastiCube. Purpose In many cases we wish to import data located in a shared network folder to the ElastiCube. To do so, we need to execu...
When using one of the file hosting sites (HTTP or HTTPS, Amazon S3, Azure Blob Storage, Google Drive, Box, Dropbox, Sharepoint, AzureDataLakeStoreGen2, AzureDataLakeStoreGen2 with SSL, FTP or FTPS, SFTP) you are able to connect to that DB by using ou...
This post explains how to retrieve google calendar meetings via a python script. Being able to connect to your own google calendar or to other’s calendars (through shared calendars within an organization) can be very powerful. As an example, you can ...
Download: IEX ConnectorIntroduction:This article will explain how to make a REST API connection to IEX Group's public stock market APIPurpose/Benefits:Connecting to stock market data can be difficult and costly. IEX provides an easy to use API that i...
Download: Coinbase ConnectorIntroduction:This article will explain how to make a REST API connection to Coinbase's APIPurpose/Benefits:This connector gives you the ability to pull in data about cryptocurrencies from Coinbase into your Sisense ElastiC...
If you organization has Excel documents stored within Sharepoint that you would like to bring into the ElastiCube Manager, you may chose to use a CDATA driver to bring this data in using an ODBC connection. Below are some lessons learned in setting ...
In order to generate a profit and loss report from the QuickBooks Desktop Connector, you will need the following tables. AccountCustom Profit & Loss Detail The Account table is a standard table available with the CData connector, while the custom ta...
NY Times Top Stories OverviewThe New York Times provides an API to retrieve a list of Top Stories and associated images by section (such Home, World, National, Politics, etc.).Sisense provides the New York Times connector as a standalone connector th...
Introduction The present post explains how to connect to twitter using their API to download the list of followers of a twitter account. The solution is based on a script in nodejs that uses this npm module and mongodb. This solution is based on the...
Connecting Sisense to Local SQL Server in Sisense version 7.4.4 and newer Open SQL server and initially connect using windows Authentication.Go to Security > Logins, right click and Create new user as seen in example below.3. Next go to “User Mapping...
The above error may occur as a result of a timeout on the SQL server. This is more likely to happen when one or more of the following conditions apply:The MySQL server is at a remote location (possibly with poor network connectivity)Heavy network tra...
Intro One may want to delete the connection credentials entered in ElastiCube Manager. This to prevent other users who have access to the server, being able to connect to the data source on their own - and getting access to sensitive data. steps: ...
Introduction: This post describes how to query your MSSQL, MySQL or Oracle DB to get the breakdown of the amount of rows in the DBs. Prerequisites: 1. MSSQL / MySQL / Oracle DB 2. SQL Client Access to the DB (including Username and Password) Procedu...
Sometimes a user can experience difficulties while defining a REST connector. This guide will help to troubleshoot these connectors. Topics: REST connector prerequisites Timeout issue Logs to review Rest Connector Prerequisites: Below are the pr...
When trying to connect to Facebook via the Elasticube Manager you may run into the error below: Solution: There is a feature called "Facebook login" which enables a different mechanism of logging into the app. Once this feature is enabled, it is ...
By default the MS SQL Server data connector will use the MS SQL Server default port 1443.To connect using a different port, use the portNumber parameter in the Additional Parameters field to specify the new port number.For example, to use port 5555 a...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
