Seal Report Forum
»
Report Edition
»
Data Source Creation
»
How to create a data warehouse from all my data sources?
Rank: Newbie
Groups: Registered
Joined: 9/10/2022(UTC)
Posts: 5
Thanks: 3 times
|
Good morning all.
Here is my situation: I have multiple data sources (oracle, mysql, etc.); I would like to create a decision-making environment, namely the ETL (Extract Transform Load). This layer must offer functions for extracting data from my various data sources, for transforming this data (homogenization, filtering, calculation) and for loading it into an intermediate ODS (Operational Data Store) or directly into the data warehouse. This layer must guarantee the delocalization of the calculation load and a better availability of the sources.
Is this possible with the seal report tool? if yes, how to create a data warehouse from all my data sources?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
if you are confortable with C#, you might use Tasks in report to perform your ETL operation, there a some native helpers you can use: Code: var helper = new TaskHelper(task);
helper.LoadTableFromDataSource(
"DataSourceName", //the name of the Report Data Source
"SourceSelectStatement", //SQL Select Statement to get the source table
"DestinationTableName", //destination table name
false, //if true, the table is loaded for all connections defined in the Source
"", //optional SQL Select Statement to get a Check table from the source connection
"" //optional SQL Select Statement to get a Check table from the destination connection,
//if both source and destination Check tables are identicals, the table is not loaded
);
with several tasks and some C#, you might control what you want.
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Data Source Creation
»
How to create a data warehouse from all my data sources?
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
