Coinbase Data Connector
Download: Coinbase Connector Introduction: This article will explain how to make a REST API connection to Coinbase's API Purpose/Benefits: This connector gives you the ability to pull in data about cryptocurrencies from Coinbase into your Sisense ElastiCube How to Install and Configure the Coinbase Connector: Step 1: Download the Connector and unzip the contents into your C:\Program Files\Sisense\DataConnectors\DotNetContainer\Connectors folder. *You may need to move your Rest dll file into the connector (replace the current one) - you can do this by going to C:\Program Files\Sisense\DataConnectors\DotNetContainer\Rest and copying the .dll to the Coinbase Connector Step 2: Restart the Sisense.Discovery and Sisense.CLRConnectorsContainer services on the Sisense machine Step 3: The driver has tables already configured for BTC, ETH and LTC You can add/remove depending what would you like to track: Step 4: Open the ElastiCube Manager, create a new ElastiCube and select the Coinbase Connector. Reference/Notes: Coinbase Website API DocumentationConnecting To The Elasticube From Microsoft Excel
Question: The purpose of this post is to demonstrate how to connect to a Sisense Elasticube from Microsoft Excel. Solution: Begin by installing the Sisense ODBC driver. https://www.sisense.com/data-connectors/odbc/ Once it is installed, go to ODBC-64 bit from the windows search (just search odbc and it will pop up), then go to the system tab and add a new connection. Then choose the Sisense ODBC Driver. Add a name and a description and then click on the empty box for elasticube names. This will prompt you for a Sisense login. If working on the same server as Sisense, the server will be localhost:8081. The username and password corresponds to your login in Sisense. Note: If you receive a licensing error, please reach out to your Customer Success Representative. Finally, select an Elasticube and save the connection. Now you are ready to connect to the elasticube from Excel. Now open a new workbook in Excel. Select the Data tab> Get Data> From Other Sources > ODBC. You will be prompted to either select an existing connection or enter a connection string. Select the connection and continue. You may be prompted for credentials. However, because the connection already contains them, they are irrelevant at this stage. You can enter a random value and click continue if it will not let you continue with an empty box. Once the connection is established, you should see all tables available in the elasticube. Please note you can not see hidden fields from the ODBC connection. In the case above, I have selected the Admissions table and loaded it into Excel. From this point you should have a populated table with the ability to refresh. You can append the query to join two tables together and customize the query. Please refer to the documentation for Excel Power Query.Getting Started With DbVisualizer
Problem There are many data sources (connectors), such as web service APIs where we not familiar with their tables/fields like Facebook, Twitter, Youtube etc. Before importing your data from a web service, you should know the data in advance. This lets you: Slice unnecessary garbage data by generating custom queries Understanding the data you’re dealing with Troubleshoot problems from the data source/connector side Solution DbVisualizer is a database tool that let’s you explore your data sets before importing them into the ElastiCube. HOW DO YOU CONNECT DBVISUALIZER TO YOUR STANDALONE DATA SOURCE CONNECTOR? 1. Go to the DbVisualizer site and download and install the latest version. *Note: You can download a version with Java or without Java. To see if you have Java installed already, open the Command Prompt and type in the following command: java -version. 2. Verify that you downloaded your connector’s driver and you can locate the connection in the following directory: C:\Program Files\Sisense\DataConnectors\JVMContainer\Connectors 3. Copy your connector’s connection string in an editor where you can easily view it. For an example of a connection string, see our Facebook example: jdbc:facebook:OAuthClientId=11276856774486;OAuthClientSecret=064c70d78567jm2b7e7e4224fad;InitiateOAuth=GETANDREFRESH;Version=2.8;CallbackURL=http://localhost/;Timeout=0; 4. Open DbVisualizer and force close "JDBC Driver Finder". 5. In DbVisualizer, go to Tools > Driver Manger and add your new connector (a) Click "+" icon to add new driver. (b) Give your connector a name. (c) Click the Driver file path and look for the JDBC driver file, and then click ok. C:\Program Files\Sisense\DataConnectors\JVMContainer\Connectors\<Your connector>\lib\cdata.jdbc.<connector> (d) Verify that the driver is loaded and you see the driver. Then, close the Driver Manager window. 6. In DbVisualizer, go to Tools>Connection wizard. (a) Give your connector name and click Next. (b) Chose the driver connector that you generated. (c) Open "C:\Program Files\Sisense\DataConnectors\JVMContainer\Connectors\<Connector>\description.json"; get the "RTK" parameter and add it to your connection string. Before: jdbc:facebook:OAuthClientId=11276856774486;OAuthClientSecret=064c70d78567jm2b7e7e4224fad;InitiateOAuth=GETANDREFRESH;Version=2.8;CallbackURL=http://localhost/;Timeout=0; After (RTK in the end of the string): jdbc:facebook:OAuthClientId=11276856774486;OAuthClientSecret=064c70d78567jm2b7e7e4224fad;InitiateOAuth=GETANDREFRESH;Version=2.8;CallbackURL=http://localhost/;Timeout=0;RTK=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (d) Add the connection string with the RTK to the "Database URL" and click Finish. (e) Verify that it connected successfully and you see all the Tables and views. (f) Go to SQL Commander > New SQL. (g) Change max rows to "-1" and start to explore your connector data. References Sisense connectors list DbVisualizer Users GuideExploring ElastiCube data with ODBC connection to R
Problem You want to determine if there are any problems with your dataset from the ElastiCube and whether the question you are asking for Sisense with R integration can be answered by the data that you have. Solution Installing the Sisense ODBC driver Download and Install Sisense ODBC driver from this link: Sisense ODBC Note: Sisense ODBC is a licensed feature Adding new Sisense Data ElastiCube Source to ODBC Open ODBC -> System DSN Add New Sisense ElastiCube data source. From the ElastiCube drop-down list, select the ElastiCube. Click Test to verify the connection to the ElastiCube. Exploring ElastiCube data in R Environment Open an R console window. Install and load the “RODBC” Package into R > install.packages("RODBC") > library(RODBC) Open the connection to an ODBC ElastiCube Database. >myconn <-odbcConnect("NW-Dan Kushner", uid="", pwd="") Viewing ElastiCube Data. Submit a query and return a result for exploring in R Discussion Exploratory data analysis is the process of exploring your data, and it typically includes examining the structure and components of your dataset, the distributions of individual variables, and the relationships between two or more variables. References http://www.statmethods.net/input/dbinterface.html https://www.sisense.com/data-connectors/odbc/Developing Custom REST Connectors
Sisense lets you import data from multiple sources using built-in connectors or by a customized connector. Sisense custom REST connectors framework enable you to program your own connectors to popular data sources which support REST services, to import data directly into the ElastiCube Manager. Custom REST connectors provide Sisense with the end points and authentication information that allows Sisense to return the requested data. To do so, you create a connector configuration file in JSON for each unique source. Data connectors overview – Native vs. Custom REST, when to use each kind? Creating a Custom REST connector workflow: Retrieving RESTful Credentials, Creating configuration files and defining them. Troubleshooting common issues. Additional resources: Example of a connector that uses CSV results as part of the connector The Sisense connections listDeleting stored data source connections from the ElastiCube Manager
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: Close the ElastiCube Manager Go to C:\Users\<currentUser>\AppData\Roaming\SiSense\Prism\LocalRepository2.0\Resources (you can type also %appdata%) Delete / rename / hide elsewhere the file: ProviderHistoryKey.res When the ElastiCube Manager will be relaunched again, the 'Add data' will not show any previous connections of any of the providers. Please note that existing ElastiCubes will still show the connection string within "Change connectivity settings" but the password (*****) cannot be copied. Also, one can only replace a table with another which has the exact structure.