Virtual Box – FTP Server Settings

I am continuing work on PROJECT ALPHA which is chartered to create a test environment for a PERL based Etract Translate and Load (ETL) solution. If you have correctly followed the previous Oracle Virtual Box articles, a working guest image of Windows 2008 Server now exists with the IIS 7.0 Web server role installed. Today, we are going to concentrate on configuring the FTP server. A local windows user account will have a home directory containing the test data file for the Perl program. The series of screen shots below…

Virtual Box – Windows Server Creation

Today, I am continuing working on PROJECT ALPHA. The project is chartered to create a test environment for developing a PERL based Etract Translate and Load (ETL) solution. I am assuming that you have correctly followed all Oracle Virtual Box – VHD Creation steps that we did last time. The installation ISO is listed as a bootable drive and will kick off when the Virtual Image is started. The series of screen shots below will walk you through installing Windows 2008 Server on the new virtual hard disk (VHD). Step…

Virtual Box – VHD Creation

Today, I am continuing working on PROJECT ALPHA. The project is chartered to create a test environment for developing a PERL based Etract Translate and Load (ETL) solution. One requirement of the project is to have a FTP server to stage test files. Window 2008 R2 Server comes with Internet Information Services (IIS) 7.5. As part of the installable server role, we can select the FTP options to meet our requirements. There are many virtual machine vendors of the market: Microsoft Virtual PC, VMWare Player, Citrix XenServer and Oracle Virtual…

Virtual Box – Know your hardware

Before today, I have written many articles that were concentrated on one topic in SQL Server or Perl or Visual Basic. Starting today, I am going to kick off a full blown development exercise named PROJECT ALPHA. The purpose of this project is to create a test environment for developing a PERL based Extract Translate and Load (ETL) solution. The following is a list of business requirements for this ETL project. A runnng trace file will be created in the LOGS directory. Connect to an FTP server using basic authentication.…