The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

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

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.

 

Hi Alteryx Connect team,

 

I would like to propose a change to a currently available feature - the alternate names.

 

On our client deployment, we are loading a number of databases, Alteryx Galleries and reporting servers. For the business users, some of the automatic names that are assigned to these source systems do not make much sense. Would it be possible to enable the alternate names for front-end editing after automatic loading? I know that the feature is available even for these assets, but I guess it is disabled in the config files.

 

Thank you very much for considering this idea.

 

Kind 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