.net - Call C# method from Tableau -

i use tableau generate reports. however, there tons of business logic in c# compute properties dynamically produce data set want feed tableau reporting, columns not exist in sql tables.

is there way tableau call c# code generate dynamic columns run reports on?

one option have c# program generate tables in form tableau can ingest, either csv, database tables or tableau extract. tableau sdk has routines can call c# generate tableau data extract (.tde) file.

you can execute these procedures on schedule or on demand. if generate tde file, can use rest api push tableau server multiple tableau workbooks can reference it.

this approach works when have bulk data might exceed web service data connector efficiently handle, , when data update frequency modest (say, when nightly or perhaps hourly updates sufficient). offloads reporting query load system. isn't best approach when data changes frequently, , reporting requirements must see minute changes.

if go route, design extracts visualizations support. best performance, include data , level of detail needed visualizations -- e.g., rollup dates.

also, handful of targeted extracts performs better 1 giant extract tries copy every detail of database.