Rhino ETL & FileHelpers Integration
Well, this image really excites me. It excites me because I got this after integration FileHelpers into Rhino ETL. This image is the result of an ETL script that joined a file against a table, did some additional processing on it and push it to a table in a third database.
I must say that FileHelpers has made this ridiculously easy to do. All I have left to do is figure out how to test such a thing effectively.
For reference, here is the complete script:
CustomerID as string
CompanyName as string
ContactName as string
ContactTitle as string
Address as string
City as string
Country as string
ConnectionString: "Data Source=localhost;Initial Catalog=ETL_Test; Integrated Security=SSPI;"
ConnectionString: "Data Source=localhost;Initial Catalog=Northwind; Integrated Security=SSPI;"
for customer in Read(typeof(Customers)).From("""Files\CustomersTab.txt"""):
source OrdersFromDatabase, Connection="Northwind":
Command: "SELECT * FROM Orders"
if Left.CustomerID == Right.CustomerID:
Row.OrderID = Right.OrderID
Row.CompanyName = Left.CompanyName
Row.ContactName = Left.ContactName
destination Final, Connection="DestinationDB":
Command: "INSERT INTO OrdersWareHousing VALUES(@OrderID, @CompanyName,@ContactName)"
CustomersFile >> CustomersAndOrders.Left
OrdersFromDatabase >> CustomersAndOrders.Right
CustomersAndOrders >> Final