Connections
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, Apache Cassandra, Hadoop, Dynamo DB, SQL server, as well as CSV files.
Important: To know about the data sources that are supported by Spectrum, refer to Spectrum Supported Data Sources.
To
access your data set:
- 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.
- Once you successfully establish a connection, you can access it in:
- Various stages of Spectrum Enterprise Designer, such as:
- The Catalog, Modeling, and Profiling processes in Spectrum Discovery