Data Sources

Version:
Current
Last modified: July 07, 2020

In the Data Sources catalog, Connect provides metadata about Files, Databases, Applications, Categories, and API sites. 

Use the icons at the top of the table to perform a Search, Excel export Excel export, or Bulk operations Bulk operation, such as transitioning a relationship, moving a listing, copying listings to a workbook, or deleting assets.

For more information how to create an asset, see Create Assets

Files

Files

Connect provides a list of files and folders harvested from the shared drives and cloud services. 

File Details

  • Path: A name of a file or directory that specifies a unique location of a file.
  • Extension: A file extension that specifies what type of file it is.
  • Size: Size specifies how much storage a file consumes, displayed in Bytes.
  • Last Modified: The most recent day the file was modified.
  • Created: The date the file was created.
  • Accessed: The most recent day the file was accessed.
  • Read only: This attribute means that the file flagged read only can be only opened or read. You cannot delete, change, or rename it.
  • Hidden: A file with this attribute enabled is invisible while browsing through files and folders.
  • Attributes: Additional attributes of a file.
  • Owner: The person primarily responsible for the file’s accuracy.
  • Group: The group to which a file belongs.
  • Permission: A permission specifies who is allowed to use and update a file.
  • Rows: A number of rows a file contains.
  • Class: A class specifies a shared characteristics for a file.
  • URL link: The link indicates the location of a file.

Extended Properties

Extended properties are extended attributes that are in the format key-value and come from the source system, for example S3. 

Relationships

The links between different assets, such as terms contained within a report. Select a related asset to open that asset. Select Open Nexus button to Open nexus, a navigable map that shows a web of connections between assets.

User Defined References

A reference to another asset can be specified by selecting an asset from the drop down.

Embed Content

In the section Embed Content you can add an external page URL to display a content on this page.

Databases

Databases

Connect provides a list of databases, schemas, tables, and views harvested from database systems. 

Description

  • Engine: Type of the database engine.
  • Hostname: A label that identifies a device in the network.
  • Port: A specific number reserved to identify specific service.

Extended Properties

Extended properties are extended attributes that are in the format key-value and come from the source system.

Relationships

The links between different assets, such as terms contained within a report. Select a related asset to open that asset. Select Open Nexus button to Open nexus, a navigable map that shows a web of connections between assets.

Applications

Applications

Connect provides a list of application objects harvested from application servers, e.g. from Salesforce. 

Relationships

The links between different assets, such as terms contained within a report. Select a related asset to open that asset. Select Open Nexus button to Open nexus, a navigable map that shows a web of connections between assets.

Embed Content

In the section Embed Content you can add an external page URL.

API Sites

API Sites

One of the very popular data sources is APIs and their endpoints. Alteryx workflows can use them as a data source.
The information about the used APIs is extracted from the workflows and cataloged in Connect.

Details

  • Action: Message to a resource to perform a certain operation, e.g. GET, POST, PUT, DELETE.
  • URIs: Uniform Resource Identifier. Address which identifies a resource.
  • Parameter/Attribute Values: Options you can pass with the endpoint to influence the response.
  • Attachment: You can upload more information for the specified API.

By default, the folder API sites is visible only to administrators. This setting can be changed anytime by an administrator.  

Relationships

The links between different assets, such as terms contained within a report. Select a related asset to open that asset. Select Open Nexus button to Open nexus, a navigable map that shows a web of connections between assets.

Categories

Categories

Connect provides a list of categories defined by admins used to asset categorization. Under Categories you find e.g. labels and security classifications.

Code Tables

List of categories which have been defined by an administrator. 

Relationships

The links between different assets, such as terms contained within a report. Select a related asset to open that asset. Select Open Nexus button to Open nexus, a navigable map that shows a web of connections between assets.

Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.