Connecting to Oracle DB with Service Name (instead of Service ID - SID)
Connecting to Oracle DB with Service Name (instead of Service ID - SID) When a customer tries to connect to an Oracle DB using a Direct Connection option, there's no option in the GUI in the ElastiCube Manager to use a Service Name, only a Service ID: Solution 1) Uncheck the Use Direct Connection checkbox. 2) In the Database server location textbox, enter the following: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=$your_ip)(PORT=$your_port))(CONNECT_DATA=(SERVICE_NAME=$service_name))) The variables you need to input are: $your_ip $your_port $service_name 3) Connect to the source.Connecting 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.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.Connecting to Live Data
Access to the most recent data is critical for effective decision making. With Sisense Live Connect, a new capability that was introduced in V. 6.6, you can Bring together historical data from the Elasticube and live data directly from the source in a single dashboard to provide a complete view of your business. To have an in-depth understanding of this capability, its benefits and limitations and the setup process, you are welcome to watch the "Connecting to Live Data" webinar (~ 30 minutes). Additional resources include: "Connecting to Live Data" webinar.Using Fixed Length Fields as a Data Source
When trying to connect to a fixed length file you will need to go through a few steps to bring it into the ElastiCube. 2. After installing, Create a System DSN in the ODBC Data Sources using the Microsoft Access Text Driver that you just installed. 3. After creating the New Data Source, give the connection a Name and select the directory where the files reside. 4. Next Click on Define Format. Select the file, set Format as Fixed Length and begin adding the fields on the right hand side. After inputting the Data Type, Name and width, click add. You'll need to do that for each field defined in the file. In the below example, I've added three fields. 5. After defining the fields, Go into ElastiCube Manager. When adding data, select Generic ODBC Driver and the new System DSN created above. Included are two attachments that you can use as sample data and as a guide to what was built here. Download: FixedLengthSample.txt fixed.ecube