How To Concatenate Sales Data From Oracle And MySQL Using EsProc.
Concatenate sales data from Oracle (2013) and MySQL (2014) using esProc script p1.dfx. Translate SQL functions for specific databases and combine results. Read more on SPL open source address.
Problem description & analysis There is a sales data table in Oracle. The table stores data of the year 2013, as shown below: There is also a sales data table in MySQL. It stores data of the year 2014, as shown below: We are trying to get data of the 35th week from both sales tables and concatenate the results. Below is the desired result: Solution Write the following script p1.dfx in esProc: Explanation A1 The standard SQL to be executed. A2 Define a sequence of data source names. A3 Define a sequence of data source types. A4 Connect to each database. A5 Translate functions in the st...