Connecting to Apache Spark
Apache Spark is a cloud data service. Use Analytics's data connector to import your organization's Spark data.
Before you start
To connect to Spark, you must gather the following:
- username
- password
- Read access
For help gathering the connection prerequisites, contact the Spark administrator in your organization. If your administrator cannot help you, you or your administrator should contact Spark Support.
Create a Spark connection
- From the Analytics main menu, select Import > Database and application.
- From the New Connections tab, in the ACL Connectors section, select Spark.
Tip
You can filter the list of available connectors by entering a search string in the Filter connections box. Connectors are listed alphabetically.
- In the Data Connection Settings panel, enter the connection settings and at the bottom of the panel, click Save and Connect.
You can accept the default Connection Name, or enter a new one.
The connection for Spark is saved to the Existing Connections tab. In the future, you can reconnect to Spark from the saved connection.
Once the connection is established, the Data Access window opens to the Staging Area and you can begin importing data. For help importing data from Spark, see Import data using the Data Access window .
Spark connection fields
Column unique names
Spark connections that are made through the Data Access window use a connection string parameter EnableUniqueColumnName that is set to 0 by default. This parameter must have a value of 0 to ensure that correct column names are retrieved when connecting.
If you create a Spark connection using a DSN rather than from the Data Access window, this value is set to 1 by default. You must change it to 0 in the Windows registry for your connection to work.
Note
Scripts that use DSN connections established in versions of ACL older than 13.1 continue to work after upgrading to version 13.1.