Stack Overflow
Stack Overflow

Questions tagged [rhino-etl]

Rhino ETL is an open source Extract, Transform and Load (ETL) library for .NET

30 questions
11
votes
2 answers

Rhino ETL opinions vs Kettle and SSIS

I am considering a tool for an ETL solution that has high daily demand and requires heavy business logic processing. I've tried kettle and SSIS so far, and also want to test for Rhino ETL. I don't care for the visual flow structure of both Kettle…
Pedro
  • 11,514
  • 5
  • 27
  • 40
8
votes
2 answers

.NET ETL Process

First some background; we are developing a datawarehouse and doing some research on what tools to use for our ETL process. The team is very developer centric, everyone is knowledgeable with C#. So far I have looked at RhinoETL, Pentaho (Kettle),…
Matt
  • 257
  • 3
  • 9
3
votes
1 answer

RhinoETL - Join two tables as input, write to two tables on output

I am writing an ETL job, in c#, using Rhino ETL I have a database on ServerA. This has 2 tables: (example) tblOrder OrderID CustomerName CustomerEmailAddress Transferred tblOrderLine OrderID ProductID ProductName Price On ServerB, it has a an…
Alex
  • 37,502
  • 51
  • 204
  • 332
3
votes
5 answers

Code in base class method not executing when using "base" keyword

I'm seeing a very strange problem when overriding an abstract method and trying to call the base class's method that I'm currently overriding. //In Dll "A" namespace Rhino.Etl.Core.Operations { using System; using System.Collections; …
Tim Gebhardt
  • 405
  • 5
  • 9
3
votes
1 answer

Chaining InputOperations in Rhino-Etl

I've just recently started using Rhino-Etl for very simple ETL processes and have had great success with it. I have a slightly more complicated scenario to address now and I didn't find the ConventionInputCommandOperation behaving the way I…
Brian
  • 151
  • 8
2
votes
1 answer

Why is my Rhino ETL process failing silently?

I have the following Rhino ETL process which fails silently. The process executes just fine however no round-trips are ever made to the DB, no exceptions are thrown and no data is ever inserted. public class UpdateLeadSources : EtlProcess { …
JeffreyABecker
  • 2,724
  • 1
  • 25
  • 36
2
votes
2 answers

Are there any alternatives to the SSIS fuzzy lookup for plain .Net code?

I'm converting several large ETL processes from SSIS over to Rhino-Etl. I got fed up with the "grahical programming" nature of SSIS. Hunting through hundreds of dialog boxes to figure out what the ETL process is doing gets old in a hurry. Several…
Craig Quillen
  • 2,057
  • 3
  • 23
  • 30
2
votes
0 answers

Rhino-etl/C# Data Mapping issue

I'm trying to retrieve data from one database and insert it into another, I am using Rhino-etl to carry out the data mapping, within a C# application. The destination database is located on a server, the source database is on my local machine. Every…
MatthewHughes
  • 21
  • 2
2
votes
1 answer

Rhino.ETL - union operation

I have got an excel work book with multiple sheets having same data schema. I have working implementation to load data from single sheet. Is there a way to merge similar records (schema) into a single set (rows) using JoinOperation or any such…
Sandeep G B
  • 3,957
  • 4
  • 26
  • 43
1
vote
1 answer

RhinoETL unable to connect to sql server

I am sure, I am missing something obvious here. I am trying to get my sample RhinoETL based app to talk to a sql server. It just would not do that. I am following the video tutorial by Paul Barriere. using Rhino.Etl.Core.Operations; namespace…
Prasanna K Rao
  • 1,086
  • 2
  • 8
  • 18
1
vote
2 answers

doing a simple SSIS-style data flow in c# without any external libraries

I'm looking for an example of a simple data flow in C# without relying on SSIS or external libraries such as Rhino-ETL (which is a very good library, BTW). Requirements: One arbitrary ADO .Net data source One arbitrary ADO .Net data…
Korey
  • 929
  • 1
  • 7
  • 14
1
vote
1 answer

How to read from SQL Server table with RhinoETL framework?

Many sample codes on RhinoETL talk about loading from csv files and insert into database. How to perform a read from SQL Server database and output its rows to console ? Do you have a sample code to perform simple dbread and batch read ? The…
Jeson Martajaya
  • 6,996
  • 7
  • 54
  • 56
1
vote
1 answer

Rhino eTL: Join operation with orphan rows

I'm using rhino ETL for the first time in a project, and I'm very impressed by its capabilities. I use a join-operation to match two datasources. Sometimes there might be missing data, so I override LeftOrphanRow to "log" the error. So I though I…
nyn3x
  • 909
  • 1
  • 11
  • 28
1
vote
1 answer

ravendb from console app

I'm trying to get raven working in a rhino.etl console to import date from sql to raven. I have a RavenInstaller: public class RavenInstaller : IWindsorInstaller { public void Install(IWindsorContainer container, IConfigurationStore…
user156888
1
vote
1 answer

successive Joins in Rhino.ETL

I have 3 tables i want to join in 1 table. How can i do that with Rhino.ETL ? I know how to join 2 tables, but not 3... Thanks John
jonathan
  • 161
  • 1
  • 4
1
2