Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

Connect or Disconnect a Remote Link

  • how-to
    +
    This topic describes how you start and stop data event streaming from a remote data source through a link.

    You incur charges when you connect a remote link.

    1. In the UI, select the Workbench tab.

    2. In the explorer, locate the link you want to connect.

    3. Click Link.

    You can view the link’s status when you hover on the link icon.

    Enterprise Analytics begins setting up the required infrastructure for the connection. Automatic data ingestion from the connected data source to all linked collections begins as soon as set up is complete. If more than 1 collection uses the link, data ingestion begins for all of them. The link’s status changes to connected.

    After you connect the link and your initial data import is complete, you can run ANALYZE COLLECTION on each collection associated with the link. The ANALYZE statement samples data in the collection so that you can apply the cost-based optimization (CBO) instead of rule-based optimization. As data in the collections changes, you can run ANALYZE COLLECTION periodically to refresh the samples. For more information, see Cost-Based Optimizer. You can also use SQL++ for Enterprise Analytics statement to connect a remote link. See CONNECT Statements.

    You can also use an SQL++ for Enterprise Analytics statement to connect a remote link. See CONNECT Statements.

    Get Data Event Stream Status

    To verify that a remote collection is receiving data through a connected link, you can compare the count of documents in the collection at different points in time.

    1. In the workbench, use the Query Context lists to specify the database and scope for the collection.

    2. Get the current count of documents in the Enterprise Analytics collection:

      SELECT count(*) FROM airline;

    3. Repeat the previous step to see the number of documents received into this collection increase.

    During data ingestion, an indicator below each collection shows the percentage of mutations that remain to be synchronized to that collection. If the indicator is not displayed, the collection is synchronized.

    Stop Data Event Streaming

    You can pause a data event stream from continuously updating the collection associated with a link, and then restart it at a later time. Pause data event streaming to stop updates to linked collections. You can restart streaming later by reconnecting the link.

    1. In UI, select the Workbench tab.

    2. In the explorer, locate the link you want to disconnect.

    3. Click Link.

    You can view the link’s status when you hover on the link icon.

    You can also use an SQL++ for Enterprise Analytics statement to disconnect a remote link. See DISCONNECT Statements.

    After you disconnect a link, you can resume data event streaming by connecting again.

    See Also