Export information about Profiles and/or Reports to SQL

Anonymous — Sat, 16 Nov 2024 02:30:46 GMT

Hi,

I need export the information about a profile, like 'number of matching', 'percentage of matching', 'Type of profile', 'Rules or indicators used'... to create a dashboard

I read for configure the destination Database, I must to configure the Database on Windows<Preferencies<Profiling<Reporting. By default the DataBase is a HSQL and I can modify to use a Microsoft SQL.

When I change the parameters and click on apply, Talend show me this message:

"The structure of <DATABASE> does not exist, do you want to continue?"

If I click 'OK', sometimes create me diferentes tables and views on my Database, however, sometimes only create me tables like TDQ_Analysis, TDQ_Indicator_Definition...

Then, when I launch a profile, no register insert into the tables or views that talend created, so,

Why sometimes talend create me tables but sometimes create me tables and views?
Why no registers insert into the tables or views?
How or where I configure correctly the parameters to insert the information into the tables?.

Thanks for all

Re: Export information about Profiles and/or Reports to SQL

yzhao — Thu, 18 Mar 2021 08:55:13 GMT

Hi,

1. the correct behavior is to create both tables and views in the schema which you have set, after the tables and view created successfully, will popup a dialog with the message: Connection successful and Datamart well configured.

in your cases, do you get this dialog or any errors in the "Error Log" view?

2. run the report will insert the data into the tables, run analysis will not insert data.

create a report by right-clicking on the analysis->New Report

or by right-click on the "Reports" node to get the "New Report" menu and add the analysis to the report.

3. if set the parameters in Window-Preferences-Profiling-Reporting page first, then create a new report, will use the parameters automatically, you can check it in the report editor "Database connection settings" part

topic Export information about Profiles and/or Reports to SQL in Data Quality

Export information about Profiles and/or Reports to SQL

Re: Export information about Profiles and/or Reports to SQL