Connecting to Salesforce
Note: This topic describes how to import data using the online Sisense Web Application. To import data through the desktop ElastiCube Manager, click here.
Sisense enables easy and quick access to databases, tables and views contained within Salesforce. The steps below describe how to connect to this type of data source.
Note: Sisense only supports Salesforce Enterprise and above.
Salesforce can be customized in various ways, therefore it's recommend to first review your deployment, and understand in which entity (account, contact etc.) and how the required data is stored. Once understood, connect to Salesforce and import a few tables to review the data. For a general outline of Salesforce entities, see Salesforce Schema and Table Description.
To import Salesforce data:
- In the Data page, open an ElastiCube or click to create a new ElastiCube.
- In the Model Editor, click . The Add Data dialog box is displayed.
- In the Add Data dialog box, select Salesforce.
- Under Basic, enter the following details:
Use Sandbox: Select if you are connecting to Salesforce Sandbox environment. If you need to connect to your Salesforce Sandbox environment, read this article in our support forum.
User Name: Enter your Salesforce user name.
Password: Enter your Salesforce password.
Security Token: Enter your Salesforce security token. See Generating a Security Token to create a token.
(Optional) Select Advanced if you want to connect to Salesforce with a JDBC connection string.
- Click Next. All tables and views associated with Snowflake are displayed.
- From the Tables list, select the relevant table or view you want to work with. You can click next to the relevant table or view to see a preview of the data inside it. When you select the table or view, two new options are displayed at the bottom of the list, Import Relationships and Add Custom Import SQL.
(Optional) By default, existing relationships between tables are automatically replicated in the ElastiCube. You can disable this by toggling the Import Relationships switch.
- (Optional) Click + to customize the data you want to import with SQL. See Importing Data with Custom Queries for more information.
- After you have selected all the relevant tables, click Done. The tables are added to your schema.
For troubleshooting Salesforce connections, see this forum post.
Generating a Security Token
Before getting started, you will need a Salesforce Security Token.
To generate a token:
- Open Salesforce and click Setup>My Personal Information>Reset Security Token.
- Click the button labeled Reset Security Token. The token will be sent to your email address.
Troubleshooting Out-of-Memory Issues
When building an ElastiCube with this connector, you might receive an "out of memory" error. Follow the steps below to add more memory.
To add memory:
- Open C:\Program Files\Sisense\DataConnectors\JVMContainer\bin\configuration.json as an administrator.
- In the line that starts with "jvmParameters:" , look for a parameter concatenated to '-Xmx', such as '-Xmx2G' or '-Xmx500M'. This parameter indicates the maximal heap size of the JVM. For example:
"jvmParameters": ["-Xmx8g", "-server", "-Dfile.encoding=UTF-8"],
If this parameter does not exist, the heap size is the default 1/3 of the machine's RAM. To modify the default size, paste the above line into your configuration.json file.
- Modify the -Xmx value according to your needs.
For additional description about this parameter, click here.
- Restart the JVM service.
- To verify that the JVM parameters you specified were taken by the machine, open the Details tab in the Task Manager, right-click a heading of any of the columns and select to display the "Command Line" column. In the Command Line column for the Java processes you will see the JVM parameter values.