<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Hesham Said on Medium]]></title>
        <description><![CDATA[Stories by Hesham Said on Medium]]></description>
        <link>https://medium.com/@heshamsaid?source=rss-5e6d08dbbd70------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*ukTVjj75r2NLJYPM</url>
            <title>Stories by Hesham Said on Medium</title>
            <link>https://medium.com/@heshamsaid?source=rss-5e6d08dbbd70------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 22:41:37 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@heshamsaid/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Migrating from IBM-DB2 on AS400 to SQL Server 2017]]></title>
            <link>https://medium.com/@heshamsaid/migrating-from-ibm-db2-on-as400-to-sql-server-2017-eca11fe0a66d?source=rss-5e6d08dbbd70------2</link>
            <guid isPermaLink="false">https://medium.com/p/eca11fe0a66d</guid>
            <category><![CDATA[as400-i-series]]></category>
            <category><![CDATA[denodo-platform]]></category>
            <category><![CDATA[data-virtualization]]></category>
            <category><![CDATA[etl]]></category>
            <category><![CDATA[ssis-package-sql]]></category>
            <dc:creator><![CDATA[Hesham Said]]></dc:creator>
            <pubDate>Sat, 26 Feb 2022 19:24:19 GMT</pubDate>
            <atom:updated>2022-02-26T19:24:19.464Z</atom:updated>
            <content:encoded><![CDATA[<blockquote>IBM db2 on as/400 is an ancient legacy Database Engine that Consists of a non-relational file based Databases (or Libraries in the Engine&#39;s Definition) so you might wonder why are we addressing this</blockquote><blockquote>in My Experience that could be similar to some people out there, I tackled it in a Project where we basically were trying to import Data from it and Migrate to a new System and all we were left with was excel sheets that’s generated by the IBM Client that helps the client manage the engine which was really not promising at first!</blockquote><blockquote>And Seriously the one reason to Connect to it as a vendor is to Migrate Data from it to be able to possess it’s data in today’s applications</blockquote><blockquote>and after A LOT of Research an outdated articles and ancient HTML webpages i was able to eventually Connect to it and extract data from it… with 2 tools… and eventually it worked</blockquote><h4><strong>So in this Article I&#39;m Going to Talk about 2 Ways to Migrate Data from it</strong></h4><blockquote><strong>The First Method</strong></blockquote><blockquote>Using an old version of SQL SERVER 2012 Data Tools using an ODBC Driver for db2 on as400 for system i that was on the client’s premise by default as it’s used by the IBM DB2 on AS400’s Client to connect on the server it self</blockquote><blockquote>so the architecture of the extraction was basically as follows</blockquote><h4>1)the DB2 Engine &gt;&gt; a Staging Area Database of SQL Server with simple one to one data flows putting each file in a Table</h4><h4>2) from the Staging Area &gt;&gt; to the Destination Utilizing all the Capabilities of T-SQL to transform the data to the Target Database (the System you are Migrating to…)</h4><blockquote>this was good at the beginning cause it was our only way and honestly we it took a lot of effort from me and the team to one to one map all of these files</blockquote><blockquote>to give you a grasp … the files were 9k+ and we only migrated around 500+</blockquote><blockquote>to be able to deliver the initial Modules</blockquote><blockquote>it was tough because especially in this 2 step architecture it means double the effort every time and this is why I felt the need to utilize a new cool concept of Data Virtualization</blockquote><blockquote><strong>So the Second Method</strong></blockquote><p>it was about Using Denodo Data Virtualization Fabric the because this would Completely change the Migration Architecture from the previouse Method to the Following</p><h4>DB2 Engine &gt;&gt; to the Target Database utilizing Denodo’s own Query language VQL in transforming data and loading it to the Target by SSIS</h4><blockquote>this made us able to Pypass the one to one migration phase all together and reduced the effort and we were 2x faster at delivering</blockquote><blockquote>so I&#39;m Gonna guide you through how to connect using JDBC ,</blockquote><blockquote>so after some research i found a set of opensource JDBC drivers</blockquote><blockquote>to connect specifically on DB2 on AS400 the project is called JT-Open</blockquote><blockquote>-and you can Download it from <a href="https://sourceforge.net/p/jt400/wiki/Home/">here</a></blockquote><p><strong>So the Initial Step</strong> is to add it to denodo Plugins and Give it a name</p><p>use it in the new connections page and use the following Credentials</p><ol><li>Name : &lt;Connection Name you Prefer&gt;</li><li>Database Adapter : choose<strong> Generic</strong></li><li>Driver Class Path : &lt;the Name of the Connection from the Initial Step&gt;</li><li>Driver Class : <strong>com.ibm.as400.access.AS400JDBCDriver</strong></li><li>Database URL: jdbc:as400://&lt;IP of the DB2 Server&gt;:446,database=&lt;liberary Name&gt;</li><li>Transaction Isolation : Database Default</li><li>Authentication : use login and password (these must be defined on the engine it self and have all the read permissions on the libraries)</li></ol><blockquote>after that it’s really about using denodo’s VQL to make views on the data and transfere it using SSIS to the Target</blockquote><blockquote>hopeing for this to be of a use for all of you out there</blockquote><blockquote>Good Luck everybody</blockquote><p><strong>Authored by<em> Hesham Badawi</em></strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=eca11fe0a66d" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>