Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesAlteryx 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.
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.
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:
2. Inside SQL Server Management Studio add Active Directory user to logins folder:
3. grant him(or her) the rights to connect to database. For test purposes I`ve granted sysadmin role:
4. Edit the connect.properties file:
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:
6. Start Alteryx Connect service and check with Ms SQL Profiler the user which is performing requests to database:
It`s Active directory (windows) user.
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
Currently if you want to get to the Microsoft Forms data you need to export to Excel,
This could be done manually or another way such as leveraging RPA.
It would be very beneficial if there was an ability just to connect directly to the data without having to leverage RPA and getting the data in real time if possible
Hello all,
I just had a meeting about Collibra. And there is a feature I would like to see on Alteryx connect : an addon to the browser of the user so that he can make a copy pasta from the dataviz application (https://marketplace.collibra.com/listings/desktop-app/ ). Very nice in demonstration and in real life.
Best regards,
Simon
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
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...
ALteryx does a great thing for offering free trial licences for those that want to do a job change/are out of job for alteryx designer. But is it possible to expand that to alteryx cloud products too?