SQL Connection - Query by Report Name/Location

[npariso]

Hello - I am trying to replicate an Excel process in Alteryx.

Currently, Excel is using an OLE DB Query Connection to query a table that is stored in a report builder.

Connection String:

Provider=ftiRSOLEDB.RSOLEDBProvider;

Integrated Security="";Password="";Location="";

User ID="";Initial Catalog=XYZ50;

Data Source=Database5;

Command Type: Table

Command Text: "xyz50" § "Finance" § "Current Prices"

Excel has a command type field which is set to table. I can't seem to find this in Alteryx.

The command text is using xyz50 for database catalog, "Finance" for folder name, and "Current Prices" for Report Name.

Is there anyway to recreate this table query in Alteryx without having to query it using SQL code?

[IraWatt]

Hey @npariso,

Alteryx has the In-DB tools which allow you to pass SQL to a Database:

Is it SSRS you are wanting to query?

[npariso]

I am familiar with using an SQL query to pull data, but I am looking to make the process a little more simple for the end user. Instead of having to generate the SQL code then generate the report I wanted them to be able to see the report directory in Alteryx and query the report from the Alteryx UI. I have gotten as far as the Alteryx UI showing the Report directory. I just dont know how to "call" that report from the DB.

I have the options in our Report wizard to see the SSRS command and the Crystal Reports command.

This is what Excel's connection properties looks like this, where the command text follows this format "[Catalog]"§"[Folder]"§"[Report Name]"

[npariso]

Bump..

[npariso]

Bump