Connections - data_integration_1 - discovery - spectrum_platform - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
How Do I
Overview
Reference
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552

A connection is a database, file server, cloud service, or other source of data that you want to process through Spectrum Technology Platform. Spectrum Technology Platform can connect to over 20 types of data sources.

To connect Spectrum Technology Platform to a data source, you need to define the connection first, before you can define the input XML. Similarly, if you want to write dataflow output to a database, you must first define the database as an external resource.

Let’s say, in your organization, data resides in disparate sources, such as Salesforce, Dynamo DB, SQL server, as well as CSV files.
To access your data set:
  1. You need to first connect to all these data sources. Spectrum Technology Platform allows you to create connections to all these and many more data sources, which you will see in the subsequent sub-sections.
  2. Once you successfully establish a connection, you can access it in: