logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Androoda50  
#1 Posted : Wednesday, October 19, 2022 7:02:32 AM(UTC)
Androoda50

Rank: Newbie

Groups: Registered
Joined: 9/10/2022(UTC)
Posts: 5

Thanks: 1 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?
epf  
#2 Posted : Wednesday, October 19, 2022 11:19:52 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,120
Switzerland

Thanks: 14 times
Was thanked: 188 time(s) in 181 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.
Users browsing this topic
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.