
When you import data into
, you are creating a reference to a source of data; the source is never touched. When the data is required for use,
reads a sample of the source data into the application for your use. Data is read into the application through an object called a connection.
The following are the supported types of connection for the product:
- Upload/Download: You can upload data directly from your local desktop. You can also save it locally on export.
- Relational sources: You can read from database tables into the product.
- S3: You can read and write to S3 locations.
Locate Connections
You already have a set of connections that you can use. Connections can be either read-only or read-write.
- In the Home page, click the Library icon in the left nav bar.
- In the Library page, click Import Data.
- In the Import Data page, your list of available connections is displayed in the left nav bar.
See Import Data Page.
Tip: To get to the Connections page from anywhere in the , click the Connections icon in the left nav bar. See Connections Page. |
Use Connections
Read-Only
- In the Import Data page, select one of the available connections.
- Navigate through the connection to select the asset to import.
- Select the object and click Open.
- In the Import Data page, review the settings of the asset in the card in the right panel. Make updates as needed.
For more information, see Import Data Page.
Write
NOTE: You cannot write or publish results until connections have been created for you. |
Write results:
You write results through a connection by specifying a set of settings.
- In the Run Job page, click Add Publishing Action.
- In the left nav bar, select the connection.
- Specify the settings for the publishing action.
- Run the job.
- When it successfully completes, the specified results are published through the selected connection.
See Run Job Page.
Publish results:
After you have written results from a job, you can publish them to other storage through your configured connections.
- In the Jobs page, locate the job whose results you wish to publish. Click its link.
- In the Job Details page, click the Output Destinations tab. Then, click Publish.
- In the Publishing Dialog, select the system to which you would like to publish the results.
- When the results are successfully published, a message is displayed.
See Publishing Dialog.
Create Connection
NOTE: Connections may be created by your . Some connections require additional configuration outside of the application. See Connection Types. |
When a new connection is created, it is initially available only to you.
Pre-requisites:
Before you create a new connection, please verify the following:
- On the datastore, you have read and (optionally) write locations.
- You have credentials to use to connect to this datastore. These credentials have permissions on your read/write locations.
- Some datastores require a special connection string, which must be inserted as part of the connection object.
Read-only:
- In the Import Data page, click the New icon in the left nav bar.
- In the Create Connection window, specify the parameters of the connection.
For more information, see Create Connection Window.
Read-write:
- In the Connections page, click Create Connection.
- Click the connection category or search for a specific connection to create.
- If a connection is grayed out:
- It may already exist. Some connections types permit only one globally available connection.
- It may not be supported in your product.
- It may be read-only.
- Click the name of the connection.
- In the Create Connection window, specify the parameters of the connection.
See Create Connection Window.
Share Connection
Through the Connections page, you can share your private connection with other users.
NOTE: When you share a connection, you can choose to share your credentials with the connection. Those credentials may provide access to specific areas of the datastore. |
- In the Connections page, locate the connection you wish to share.
- In the context menu for the connection, select Share....
- Specify the type of sharing from the drop-down and, if applicable, the users with whom you wish to share.
See Share Connection Window.
Delete Connection
NOTE: You can delete a connection only if you are the connection owner and the connection is not used to import any datasets. |
- In the Connections page, locate the connection to remove.
- In the context menu, select Delete....
- The connection is deleted.
See Connections Page.