Connecting to DynamoDB
The Sisense DynamoDB connector is a standalone connector that allows you to import data from the DynamoDB API into the ElastiCube Manager. After you have downloaded and installed the connector, you can connect through a connection string you provide Sisense in the ElastiCube Manager. The connection string is used to authenticate users who connect to the DynamoDB API. To obtain a connection string, you will need to create a DynamoDB developers account.
Once you have connected to DynamoDB, you can import a variety of tables from the DynamoDB API.
This page describes how to install the DynamoDB connector, how to connect to DynamoDB with a connection string, and what tables you can import into the ElastiCube Manager:
- Installing the DynamoDB Connector
- Connecting to the DynamoDB REST API
- Adding DynamoDB Tables to your ElastiCube
- DynamoDB Tables
Sisense provides the DynamoDB connector as a standalone connector that you can download and add to your list of default Sisense connectors.
To install the DynamoDB connector:
- Download the DynamoDB installation file.
- Open the installation file and click Install.
- After the installation process is complete, click Close.
The DynamoDB connector is displayed in the ElastiCube Manager under Add Data > Web Services.
The connection to DynamoDB is made using your AccessKey, SecretKey, and optionally your Domain and Region. Your AccessKey and SecretKey can be obtained on the security credentials page for your Amazon Web Services account. Your Region will be displayed in the upper left-hand corner when you are logged into DynamoDB.
- AccessKey: Your AWS account access key. This value is accessible from your AWS security credentials page.
- SecretKey: Your AWS account secret key. This value is accessible from your AWS security credentials page.
- Domain: Your AWS domain name. You can optionally choose to associate your domain name with AWS.
- Region: The hosting region for your Amazon Web Services. Available values are NORTHERNVIRGINIA, OREGON, NORTHERNCALIFORNIA, IRELAND, SINGAPORE, SYDNEY, TOKYO, and SAOPAULO. The default value is NORTHERNVIRGINIA.
Sisense uses connection strings to connect to DynamoDB and import data into the ElastiCube Manager.
The connection string to connect to DynamoDB has the following structure:
An example of a connection string:
jdbc:dynamodb:Access Key=AKIAJH283HDH2932DQ;Secret Key=vG07bFgSmvfgsrdfgHsB6iQU/HVOqO9L9g;Domain=amazonaws.com;Region=OREGON;
Note: To switch between accounts, you need to delete the file OAuthsettings.txt file located at …\Users\xxx\AppData\Roaming\CData\DynamoDB Data Provider.
To add DynamoDB data:
- In ElastiCube Manager, click Add Data and then, DynamoDB. The Connect to DynamoDB window is displayed.
- In Datasource Connection String, enter your connection string.
- Click Connect to Server. DynamoDB is displayed in the Select Database list.
- Click OK. Sisense connects to DynamoDB and displays a list of tables available for you to import.
- Select the relevant tables and click Add. The tables are displayed in the ElastiCube Manager.
Switching between Accounts
When you connect to the DynamoDB data source, Sisense saves your OAuth values in the file OAuthsettings.txt file located at …\Users\xxx\AppData\Roaming\CData\DynamoDB Data Provider on your Sisense server. To connect to the DynamoDB data source with another user on the same machine, you must delete the OAuthsettings.txt file. Sisense will then generate a new file for that user.
Another option to support multiple users is to define the location and file name of an OAuthsettings file for each unique user in your connection string through the OAuthSettingsLocation parameter. When each user connects to the data source, Sisense generates the OAuth file with the file name you specify in the location you define. In the examples below, two users are allowed to access the DynamoDB data source and for each user, Sisense generates a file that contains that user’s OAuth values in the location defined in the string.
In the example above, to OAuth files are created, one for John and one for Sally in the location C:\DynamoDB\auth\.
This is useful if you support many users who each need to access the DynamoDB data source.
The Sisense DynamoDB connector allows you to import the following tables into the ElastiCube Manager.
|Movies||Sample data file that contains information about a few thousand movies from the Internet Movie Database (IMDb).|
Sisense support accumulative builds for all numeric and dates data types. However, the data must be sorted before building the ElastiCube.
|18.104.22.168||April 20, 2017||Sisense automatically retries a query attempt for certain errors|
|22.214.171.124||March 21, 2017||TypeDetectionScheme in the connection string works as expected|
|126.96.36.199||March 3, 2017||Support for Accumulated builds with Sisense V6.6 Beta installed|