tag:blogger.com,1999:blog-86806032089155111922024-02-08T10:13:45.986-08:00EplSiteETLCarlos Kassabhttp://www.blogger.com/profile/00389959756339201003noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8680603208915511192.post-26518364351426270682014-12-20T12:25:00.004-08:002014-12-20T12:27:02.095-08:00<div style="text-align: center;">
<span style="font-size: large;"><b>EplSite ETL 1.3 has been released. </b></span></div>
<br />
<br />
Release Notes<br />
<br />
Release date: 20 December 2014<br />
<br />
<u>Bug Fixes</u><br />
<br />
- When saving a query, it was not set as the default query and it was causing confusion.<br />
<br />
<u>Improvements</u><br />
<br />
- The query window is now flexible.<br />
- There is a button to export directly to Excel format and we can use Excel <br />
or Libre Office to open the documents.<br />
- Codemirror libraries were updated.<br />
<br />
Note. There is not upgrade process, you will need to copy all programs and overwrite<br />
previous versions and, create a new field in the EplSite.sqlite database, in the<br />
queries table.<br />
<br />
If you want to upgrade, this is the create query for the queries table:<br />
CREATE TABLE "eplsite_etl_sqlqueries" ("SQLQueryID" INTEGER PRIMARY KEY NOT NULL ,<br />
"SQLQueryName" VARCHAR NOT NULL ,"SQLQuery" TEXT NOT NULL ,"DefaultDataSource" INTEGER DEFAULT (0) )<br />
The last field is the new field.<br />
<br />
<br />Carlos Kassabhttp://www.blogger.com/profile/00389959756339201003noreply@blogger.com3tag:blogger.com,1999:blog-8680603208915511192.post-84092716324772812872014-12-18T15:54:00.003-08:002014-12-18T15:54:30.349-08:00<h2 style="text-align: center;">
<a href="http://www.kassabconsulting.com/index.php/creating-a-data-transformation-step-by-step">Creating a data transformation step by step</a></h2>
<br />
<br />
I created a basic transformation step by step sample in order to have
documentation about EplSite ETL, this is the firs document, in a future
sample i will show how to insert data in a tabla, anyway, you could see
it in the sample data transformation that already exists in EplSite.<br />
You can get the file from this link:<br />
<br />
<a href="http://sourceforge.net/projects/eplsiteetl/files/Creating%20a%20data%20transformation%20step%20by%20step.pdf/download"><span>http://sourceforge.net/projects/eplsiteetl/files/Creating%20a%20data%20transformation%20step%20by%20step.pdf/download</span></a><br />
<br />
<br />
<hr>Carlos Kassabhttp://www.blogger.com/profile/00389959756339201003noreply@blogger.com0tag:blogger.com,1999:blog-8680603208915511192.post-80767575650904760942014-12-18T15:52:00.001-08:002014-12-18T15:52:38.850-08:00<h2 style="text-align: center;">
<a href="http://www.kassabconsulting.com/index.php/hypertextperl">HyperTextPerl</a></h2>
<h2>
</h2>
HyperTextPerl is a Perl program that parse Perl code inside html pages and also runs Perl native code without html.<br />
<br />
EplSite ETL is based on this technology, it uses cgi technology to accomplish the web part.<br />
For simplicity the cgi technology was used and the focus was on the development of the ETL itself.<br />
<h2>
</h2>
<hr />
Carlos Kassabhttp://www.blogger.com/profile/00389959756339201003noreply@blogger.com0tag:blogger.com,1999:blog-8680603208915511192.post-40344549691688332922014-12-18T15:48:00.004-08:002014-12-18T15:48:35.557-08:00<h2 style="text-align: center;">
<a href="http://www.kassabconsulting.com/index.php/eplsite-etl-overview">EplSite ETL OverView</a></h2>
<br />
EplSite ETL is your own tool to do easy the data migrations and fact table
creation, doing extraction, transformation, validation and load in a
very fast way.<br />
<br />
It was built by people involved in data migrations so, it contains
the necessary to do the migration(Extract Transformation, validation and
load) and do it well.<br />
<br />
When you use EplSite ETL, focus on the positive things, you will see a
lot of benefits in using this ETL, it does not need a lot of resources
as most of the actual Java based ETL software.<br />
So, positive things are:<br />
<br />
- Open Source.<br />
- Easy to use.<br />
- Low resource consuming.<br />
- Just the necessary tools to do the job.<br />
- Web interface.<br />
- Very easy to customize it because it is developed in Perl, all the source code is included.<br />
- It is possible to run transformations using cron jobs on Linux or task manager on Windows.<br />
<br />
Maybe the only missing part would be a graphical environment to to
the design of the transformations but with the interface EplSite ETL has
it is nod needed that.<br />
Visit the project on sourceforge to get the files:<br />
<br />
<a href="http://sourceforge.net/projects/eplsiteetl/?source=navbar">http://sourceforge.net/projects/eplsiteetl/?source=navbar</a><br />
<br />
<br />
<br />Carlos Kassabhttp://www.blogger.com/profile/00389959756339201003noreply@blogger.com0