community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx connect Knowledge Base

Definitive answers from Connect experts.
We're constantly working to improve your Connect experience. Find out what new features, improvements, and bug fixes we released with this version of Connect! Here is a summary of what has changed in 2019.4.  Notify on Mention / Dislike / Decertify A notification will go to the user that was mentioned on an asset. Thanks to this feature the users can see where they were mentioned and respond easily. Also, the actions Dislike and Decertify will now trigger a notification. OpenJDK Upgrade Connect has been upgraded to OpenJDK11 for security and performance improvements. Tableau Loader with New GraphQL API We’ve added support for new Tableau GraphQL API, so you can load column-level lineage into Connect (from Tableau worksheets columns into data source columns).     Using the Tableau GraphQL API in Connect allows us to display the data source fields of a worksheet and their details that built every single field on the list (such as servers, databases, schemas, tables, and columns). All the information can be tracked by clicking a link associated with each of the data source fields.   To view this information in Connect, go to your Tableau reports, click the desired report, and the Datasource fields section.     Uploaded File Types Restricted by Default Uploaded file types are restricted by default. These restrictions can be changed anytime by an administrator. To view and change the file types list, go to Administration > Connect Configuration > Instance Settings. QlikView Metadata Loader Faster Parsing We’ve improved the speed of parsing of QlikView files by smarter way of detection of metadata headers in QlikView files, so just metadata are read over the network resulting in faster harvesting especially for larger datasets. Connect Performance Improvements We’ve made many performance improvements regarding the speed of metadata loading, system startup, asset detail rendering, and removing inactive versions in bulk.   Asset Identity Switch In addition to other improvements, we have added Asset Identity switch for columns. Administrators can now decide if columns will be separate assets or parts of the table asset (default). This feature improves not only performance but will bring significant load and rendering improvements as well.   To access the Asset Identity switch, go to Administration > Asset Configuration > Asset Identity. Catalogued APIs We have added brand new API Catalog which allows you to automatically catalog APIs and their endpoints from your workflows. This feature is by default available for administrators only but it's up to them to share the API Sites folder with other users or groups. Go to main menu > Data Sources > API Sites. API Catalog has 2 layers. It’s listing all API sites (e.g. Tableau, Salesforce) and their endpoints (e.g. getAllDatasources). Support for Multiple Tableau and Alteryx Servers We’ve been following up on our customers’ feedback and added support to load multiple different servers for Tableau and Alteryx into Connect. Metadata Loaders We've made a number of enhancements to our Loaders with 2019.4: You can now upload metadata to Connect from Alteryx Promote. DB2 Loader was redesigned to support different DB2 platforms at once. S3 Loader was redesigned to speed up the loading and handle large volumes of files. For all database loaders we have added Column references which display all column level mappings. Fixed Issues Here is a list of some issues fixed in the latest release. To check a complete list of fixed and known issues please see the Connect 2019.4 Release Notes. Resolved: Custom Fields Lost after Reloading Asset Custom fields of an asset were lost once that asset was reloaded. Now after re-running the metadata loader, the custom fields stay as they are without being removed. Resolved: Admin API Not Enabled for the Fast Deployment in Gallery Admin API was not enabled for the fast deployment in Gallery. There was no error message when the Test connection or Harvest button was pressed. Now the error message appears on all appropriate screens when Admin API is not enabled. Resolved: Only Superadmin Is Able to See the "Download Service Provider Metadata" Button Only the superadmin was able to see the "Download Service Provider Metadata" button on the SSO configuration page. This issue was resolved by allowing this function for the members of admin role. Resolved: Only Superadmin Is Able to Perform the H2 Backup Only superadmin was able to see and do the H2 backup in Administration Console. This issue was resolved by allowing H2 backup for the members of admin role.
View full article
Metadata Loader Categories   In this article you'll find detailed information about the loader categories and which exact information is extracted by each of the loaders we support. Each type differs in the object hierarchy, structure of the objects, and detail of the objects.  There are five types of the metadata loaders:  Database Loaders File Loaders Visualytics (Report) Loaders Workflow Loader Other Loaders     Database Loaders Database loaders are used to harvest metadata about database objects such as database server (RDMS), catalog, schema, table/view/procedure, column. An example can be an Oracle database with all available objects, descriptions, and relationships within the objects in the database. Connect supports database metadata loader for these technologies: Teradata, Snowflake, Apache Hive, IBM DB2, Exasol, Oracle, Microsoft SQL Server, MySQL, SAP HANA, Amazon Redshift, HP Vertica, PostgreSQL, Apache Impala.   File Loaders File loaders are used to harvest metadata about file systems such as file bucket or folder with subfolder structure, individual files, sheets (when available e.g. on xlsx file), and columns on files you can parse for the structural information (xls(x), csv, yxdb, avro …). For files with structure you can store also profiling information such as number of rows, not nulls, blanks, uniqueness, and average length. Connect supports file metadata loader for the following technologies: Amazon S3, Apache Hadoop, Microsoft Azure Data Lake, Files loader (windows shared drives).   Visualytics (Report) Loaders Visualytics are used to harvest metadata from reporting platforms such as report workbook, worksheet, datasource, and detailed columns. Connect supports visualytics metadata loader for these technologies: Tableau, Microsoft PowerBI, QlikView, Qlik Sense.   Workflow Loader Workflow loader is used to harvest metadata from the Alteryx Gallery. Connect supports only AYX Gallery Loader.   Other Loaders This category describes loaders that don't belong to any of the above-mentioned categories, such as: Alteryx Promote loader is used to harvest metadata about Promote models published on a Promote server. Microsoft Azure Data Catalog loader is used to exchange metadata from Azure Data Catalog about databases, files, and business terms. Salesforce loader (without data profiling) is used to harvest metadata from the Salesforce application.    Overview of Available Objects for Each Loader Type Loader Type Available Objects  Databases db server, catalog, schema, table / view / procedure / column Files file bucket (AmazonS3) / folder, file, sheet, column Possible data profiling (additional information about features and content of the files). Visualytics (reports) server, site, project, workbook, worksheet, datasource, column Tableau: site, project, workbook, worksheet Microsoft PowerBI: workspace, workbook Insight QlikView: folder, Qlik data files (data profiling - .qvd, .qvx); report, worksheet; Qlik Sense: stream, workbook, worksheet, report objects (names and types of charts, dimensions, measures) Workflows workflow, input, output Others Microsoft  Azure Data Catalog: glossary, databases, files (without data data profiling) Alteryx Promote loader: predictive model Salesforce loader: Salesforce tables     How to Use and Configure Loaders More information on how to use and configure the metadata loaders you can find on the following pages: The Alteryx Online Help pages Schedule Metadata Loaders and Load Metadata into Connect specify how to use the metadata loaders from Designer. Now you can run metadata loaders directly in Connect by selecting Connections in the Admin Menu. You have the possibility to start the harvest immediately or to set up a regular harvest. Go to Admin Menu > Connections to configure and run the metadata loaders. For more info see: How To: Fast Deployment of Metadata Loaders in Connect.   Overview of available loaders while using the fast deployment.    
View full article
Have you ever wondered what are the limits of Connect? How many entries can you store in Connect? Great questions!  In fact, no hard limit on the number of entries is set. The number around 2M entries is the number on which the performance tuning in the 2019.1 release was done.
View full article
How To: Recover the Home Page after Restoring Connect   Did you know that restoring Connect can finish with a broken home page? In this article you will find an easy way to recover the broken home page after the restoration is complete.   Let’s assume you performed a restore of the H2 database. But when you open Connect after completing it, the home page you normally see is gone.   Instead of your home page, you're seeing something like this:       To fix the broken home page, you need to perform a full reindex of Connect after Connect starts. This is also mentioned on the screen you’ll get after completing the restore.     How To: Perform a Full Reindex   To perform a full reindex of the database to complete the restoration:   Log in to Alteryx Connect. Click your icon in the top-right of the screen and select Administration. From the Admin Menu, click Reindex. Click Full Reindex. After the full reindex is completed, you should be able to see the home page.
View full article
We’ve been working hard to follow up on our customers’ feedback and make a bunch of enhancements to Connect. Here’s an overview of the changes in 2019.2.  
View full article
Alteryx Connect  is great at finding data assets that exists within enterprises which helps data workers to  shorten their journey to data-driven insight. One of the steps to refresh the metadata is to schedule the Metadata loaders. In this process, the data assets can be created, changed or removed. To take a look at this change log, we can take a look the backend of Connect - the H2 database.
View full article