Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Connect Ideas

Share your Connect product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Featured Ideas

Alteryx Connect has option for bulk export and import to and from Excel, but doing so is a manual operation.

This idea is to provide Designer connectors that operate like the Connect bulk export and import.

This would allow Connect content to be reported and improved using automation.

 

The metaloaders provided with Connect do a fine job doing loading a generic extract from many sources.

This new feature would allow Connect customers to improve on that generic extract without making changes to the metaloaders. 

Customer changes to metaloaders makes installing new releases expensive and risky.

Deploying Connect on MS SQL Server (https://community.alteryx.com/t5/Alteryx-Connect-Knowledge-Base/Deploy-Alteryx-Connect-on-MS-SQL-Dat...) we would like to use integrated security option when we setup jdbc connection.

 

For now workaround looks like this:

 

1. Copy the file “sqljdbc_auth.dll” into Alteryx folder:

sergiussrussia_0-1635855989196.png

 

2. Inside SQL Server Management Studio add Active Directory user to logins folder:

sergiussrussia_1-1635855989202.png

 

3. grant him(or her) the rights to connect to database. For test purposes I`ve granted sysadmin role:

sergiussrussia_2-1635855989205.png

 

4. Edit the connect.properties file:

sergiussrussia_3-1635855989206.png

 

Here we don`t need user and password lines at all. We only need to add “integratedSecurity=true”

Because there will be used credentials of user, using which Alteryx Connect was started, not the user which was provided in these red records.

But we still need these two records, because Alteryx will give us an error if it will not see these records inside config file during startup.

That`s why these records still must exist inside connect.properties file.

 

5. Setup Alteryx Connect service to start Alteryx Connect with Active Directory user, for which we granted access in SQL Server:

sergiussrussia_4-1635855989216.png

 

6. Start Alteryx Connect service and check with Ms SQL Profiler the user which is performing requests to database:

sergiussrussia_5-1635855989252.png

It`s Active directory (windows) user.

 

We are moving our measure specifications that are in a PDF format to the Connect glossary.  We would like to keep the formatting that exists in the PDF when copying the spec.  However, the format doesn't always copy over.  It would be nice to have the 'Format Painter' option similar to what is in MS Word where you can copy the format from one line to another line.

 

  • New Request

Hi Alteryx team,

 

It would be great if it was possible to install/upgrade and configure Alteryx Connect using scripts. This would enable us to deploy Alteryx Connect using script deployment tools such as Urbancode Deploy. This functionality was recently requested by one of our customers, who has most of their application installations/upgrades automated this way.

 

Thank you very much for considering this idea.

 

Kind regards,

Jan

Hello Alteryx Team,

 

Would you consider creating a metadata loader for Databricks? I can imagine this being a part of the Analytical workflows section and be catalogued in a similar way like Alteryx workflows. On a number of clients, we are seeing Databricks jobs being used as a complement to Alteryx workflows and a possibility to have them both catalogued in Alteryx Connect would be of great benefit.

 

Thank you very much for considering this idea.

 

Regards,

Jan Laznicka

0 Likes

After loss of data on our client's Alteryx Connect instance, we started to think about regular automated backup of the Connect (or at least of the H2 database). It would be great if this was implemented in Connect (currently we have to do it manually) and we won't need to writte an extra script.

 

Thank you very much for consideration of this feature!
Best Regards,

JanK

0 Likes

When I add descriptions to tables or columns in Connect then use that asset in a workflow, I would like to see the same table and column descriptions within the metadata in Designer. To illustrate, I've shared some screenshots...

 

Connect_meta_1.jpg

 

Connect_meta_2.jpg

  • New Request