Question on database connection userid and password management

Hi, I have an excel worksheet that keep the data schema name, userid and password for various databases that I have access to. Company policy required us to update the password every 3 months. This will be used by all Alteryx workflows that I am running. Is there anyway that I can input this worksheet in the first step of my flow and pass the userid and password to each input that connect thru ODBC connection? Is there a better way in Alteryx that can help me to handle this situation. Following is my excel worksheet format

DB_TYPE Schema_name User_ID PASSWORD

Teradata schema_a user1 pw1

Oracle schema_b user2 pw2

Thanks...

Best Practices

Help

Download

Database Connection

Accepted answers

randreag

yes Of course.

1. create the connection and select Connection File, save it in your path

2. Then you put the paths of the files in the worksheet and read it with an input tool

3. And the last step is using a Dynamic Input Indb

I attach a simple example in order you get the idea

I hope it helps!

Example dynamic Indb.yxmd

All comments

AbhilashR

Hi @Dennis_L, I have seen folks use different approaches to address this scenario. The org. I work with uses Gallery Data Connections which are created and controlled by the Gallery Admins and pushed to individual Designer License holders. All that the License holders need to do is connect to the database Alias that will be made available to them (in their designer), and admins control password changes etc. I have included two links below that throw more light on this subject.

https://community.alteryx.com/t5/Alteryx-Server/How-To-Create-a-Database-Connection-Share-Through-Gallery-Admin/ta-p/46409

https://community.alteryx.com/t5/Alteryx-Server/Gallery-Data-Connections-FAQ/ta-p/452293

I hope this helps.

randreag

hello @Dennis_L

In the past I had a similar case and what we did was, using INDBC tools create the conections files to each of your data bases and put that path in a worksheet.

Depends on the conection you need you select the record in the worksheet and it will search for the file.

In this order, when you change the password and username, your file will be updated, but it will be transparent for your workflows.

I hope you get the idea an dit helps you.

Dennis_L

Thanks.. I like the idea but we don't have a Alteryx server installed in our site. We will use the same idea when we have the server setup. Thanks a lot

Dennis_L

Thanks @aruiz-itp

That is the solution that I am looking for. Can you share a bit more on how to setup in INDBC and how my workflow can call from the connection files..

Thanks..

randreag

yes Of course.

1. create the connection and select Connection File, save it in your path

2. Then you put the paths of the files in the worksheet and read it with an input tool

3. And the last step is using a Dynamic Input Indb

I attach a simple example in order you get the idea

I hope it helps!

Example dynamic Indb.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280