cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.
Announcement | Looking to expand your Alteryx skillset?! Check out the latest set of interactive lessons in Alteryx Academy: Creating Analytic Apps

Alteryx In-DB Connection File

Alteryx
Alteryx

As users collaborate, the sharing of workflows that connect to databases can be helpful. The In-DB Connection File type allows for this. A database connection is saved as an .INDBC file so it can be packaged with a workflow.

 

To create an In-DB Connection File that can be used on your workflow, go to Options > Advanced Options > Alias Manager > In-DB Connections.

 

N1.png

 

Select the Data Source from the dropdown (1), for our example we will select Oracle, then pick File for the connection type (2), this option will ask you to navigate to a folder where the INDBC file will be stored and also will ask you to provide a name for this file (3).

 

N2a.png

 

Then proceed to set up your connection as you would normally do by selecting the appropriate driver and setting up the connection string for Read & Write.

N3a.png

 

 

Now that your connection file is created, the next step is to connect to your database using this file. Bring a Connect In-DB into your canvas, click on the dropdown for the Connection name and select Open File Connections, browse to your file and select it.

 

N3.png

 

The next thing you will see the list of tables.

 

N4.png

 

 

Select the table and/or write your query in the SQL Editor and proceed to build your workflow.

 

Now that you are ready to share, package your workflow by going to Options > Export workflow, notice that the INDBC file is being packaged with the workflow.

 

N5a.png

 

 

At the receiving end, the database drivers/client, data sources for that database should be installed and set up. The INDBC file looks like below, the password is encrypted.

N5.png

 

Note: Workflow and all images created in this article are from Alteryx version 10.1

Comments
Meteoroid

Hi,

I am unable to see the Alias repository creating option in Alteryx 11.

 

Alteryx alian repository.png

 

Can you anyone help me out?

 

Thanks,

Manidipa

Meteor

@mbane1:

 

In Designer, navigate to Options > Advanced Options > Manage In-DB Connections.
The rest of the screens appear to follow in order once in the In-DB Connections Manager.

 

Regards

Meteoroid

What is the "valid connection string"   I can't find instructions for this.   How do I tell it what DB to go to?

And this seems to use OCI, which is 32 bit, right?  But other documentation says IN DB uses only 64 bit drivers.

Alteryx Partner

Never mind. I figured it out. You have to give the connection a name and determine where it is going to be saved then go on and create the connection and click ok.

 

I still think there is a gap in the instructions for this. while we can make in-DB connections via the Manage In-DB connections tab, I do not see any instructions or guidelines on how to create the .INDBC file.

 

Can anyone address this please? Thanks

Has there been any updated on this? How do you create the .INDBC file in 11.0?

 

I still think there is a gap in the instructions for this. while we can make in-DB connections via the Manage In-DB connections tab, I do not see any instructions or guidelines on how to create the.INDBC file.

 

Can anyone address this please? Thanks

Alteryx
Alteryx

Hello @connelbell

 

This article will soon be refreshed to show the options for the latest released version.

 

Per @KJennings helpful comment, starting with version 11 you can get to manage In-DB connections right after Advance Options, navigate this way : 

Options > Advanced Options > Manage In-DB Connections

 

As for the creation of the file INDBC file. The below will show when selecting manage in-db connections

(1) select the data source, for my example I picked Oracle

(2) There are three options for Connection Type (File, User and System), select File

(3) Once File is selected, the Connection file box will show, click on the three dots... here is where you navigate to the place where you want to save your INDBC file, give your file a name

indbfile.jpg

 

When you click the three dots, a browse window will open, give your file a name and click on Open (bottom right hand side)

 

 

indb2.jpg

 

Then fill out the rest of the connection information for Read and Write. Click OK and the INDBC file will be created.

 

indb3.jpg

 

 

Very helpful! Thank you.

Asteroid
What do I do if I only want read access? When I am at the "Manage In-DB Connections" window in Alteryx Designer 11.x I can choose between a read and a write tab. I only need to use the read tab but when I try leave the connection string in the write tab empty I get an error because the write tab is blank. What can I do?
Alteryx Partner

@PeterPetersen I typically just select the same read and write option since you cant leave it empty.

 

As per being able to write to the db, I think that's set at the database level. At least with the databases I've worked with, whether alteryx was set to read or write did not matter because I know at the database, I cannot write anything.

Meteor

Hi, everyone, 

 

I already created a workflow that has few In-DB tools, when I first did that I did not go through the create .INDBC file, and now i want to export the workflow to share but it errors out at their end because of the connection. what are my options here? I am not going to recreate the workflow since it is a huge one, and when i export the workflow i don't see any .INDBC files packaged, I only see a .tde (tableau extract) packaged, which is my output file from the workflow.

 

your help and suggestions are highly appreciated..

 

Thanks

Rawan