Sources
Sources help you organize data sources to which Ataccama ONE can connect, such as databases, data lakes, object storages, file systems, BI and analytics tools, and more.
See Supported Connectors for the full list of supported connectors.
Understanding sources and connections
A source is a business representation of a data source, while a connection is the actual technical integration.
For example, your Marketing department might have a single source called "Marketing Analytics" containing multiple connections:
-
Salesforce connection for customer and campaign data.
-
Google Drive connection for market research data.
-
Tableau connection for performance dashboards.
Meanwhile, your Data Platform team might have a "Cloud Data Warehouse" source with connections to Snowflake (production data), Amazon S3 (raw data lake), and Databricks (analytics workloads).
How to organize sources and connections
You can organize your data sources in different ways, for example:
-
Single source, single connection: Simple setups where one business unit uses one data source (for example, a "Sales CRM" source for Salesforce data).
-
Single source, multiple connections: When logically related data lives in different systems (for example, a "Customer Data" source connecting to PostgreSQL for operational customer data, Amazon S3 for customer data extracts, and Tableau for customer analytics dashboards).
-
Multiple sources: For clear organizational boundaries or different stewards (for example, separate sources for each department).
Connect to a data source
To connect to a data source:
-
Create a new source or edit an existing one. To edit an existing source, go to Sources > [your source] > Connections.
-
Add a connection to your data source, including:
-
Connection parameters
-
Authentication credentials
-
Optional advanced settings.
For detailed guides and reference information, see Supported Connectors.
-
-
Test the connection to verify credentials and access.
-
Save and publish your source.
-
Start populating your Catalog. See Discovery Actions in Catalog.
Create source
-
Navigate to Catalog > Sources.
-
Select Create.
-
Fill in the following:
-
Name: Give your source a clear name.
-
Description: Explain what the source is used for or provide other useful information.
-
Deployment (Optional): Choose the deployment type.
-
Stewardship: Select the source owner and roles. See Stewardship.
-
-
Save your changes.
Test connection
To test and verify whether the data source connection has been correctly configured, select Test Connection.
If the connection is successful, save and publish your connection. Otherwise, verify that your configuration is correct and that the data source is running.
Save and publish
Once your connection is ready, save and publish your changes. The connection is now available for other users in the platform.
In case your configuration is missing required fields, a list of detected errors is displayed. Review your configuration and resolve the issues before continuing.
Edit connection
To edit a connection, go to Sources > [your source] > Connections and select the connection you want to modify. In the Connection detail section, open the three-dot menu and select Edit.
Alternatively, on the source Connections tab, open the three-dot menu next to the connection and select Edit.
For connector-specific configuration, see Supported Connectors.
|
Saving changes to an existing connection removes all configured credentials as a security precaution. You’ll need to re-enter credentials before you can test or publish the connection again. If you opened the connection just to review it, leave the page without saving to keep your credentials intact. |
Was this page useful?