ETL jdbc parameter

[victor]

Ok, ok, first of all:

ODS database should have been automatically created by Datasourcer once you start, but I see you went the hard way about it.

Usually, when there is absolutely no data coming into Datamart, the cause for it is either you forgot to activate the report inside DMA, ETL Assistant or you have some more serious issues. You said you already have data inside ODS, so your ETL has trouble transferring the data to DM. Before we go the difficult route, once again, let's do a quick check:

1. you used ETL Assistant to configure connection to datamart, right?
2. open DMA and see if your reports are activated
3. inside the reports, click on data and see if you have data inside
4. you ran create_db once, and then you ran run_trans_once and then run_trans_agg or did you do create_db, and run_trans_agg?
5. what does your ETL log say?

Based on your last post, I see that you did (2) and (3) for sure, but just in case....

My hunch would be:

1. you forgot ETL assistant
2. you do not have the right user inside etl.properties

Vic

[SorinM]

Yes, i did 2 and 3. I see data in report in DMA.
I didn't ran run_trans_once manually, i let ETL to do it.
Now It seems OK, i see data in Brio charts and reports.

I reinstalled Datasourcer because i modified also the ODS database user. I didn't know the easiest solution and that's why i reinstalled it.

Thank you very much for help.