ETL from 250+ disparate customer host systems

bg4 at 19h32
20
May
2010
ETL from 250+ disparate customer host systems

My task is to produce an ETL process that pulls data daily from our customer systems (which can be most any database/OS). The data will be loaded into our central system, an analysis will be run and the aggregate data solution sent back to all customers.

Any recommendations for tools to achieve this scenario? I'd like to be able to connect to each customer's host (via whatever protocol) and execute the ETL from my central l
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
I am trying to model a Customer Dimension with Educational and Employment details and I want some advice on how to model this scenario A Customer can have several levels of Education like schooling, college, university, training (one to many realtionship
I have a question regarding de-normalizing customer data to create a single customer dimension! Let's say our OLTP customer information is made up of 2 tables. 1) Customer Table (customer name, customer type, etc...) 2) Address Table (address1,
Hi, I started to play with Media Companion 3.019 running under Vmware Fusion on a MacBook Pro. Mc scrapes my test movies located in a shared folder on the mac, it creates the video_ts.nfo file, and it places them in the correct locations. These
I have a requirement to start capturing addresses in our data warehouse for detailed analysis of customer returns. Up until now, analysis at postal code has been sufficient. The company I work is mail order, so the addresses I need to record
As part of an Orders dimensional model, I am attempting to design the Customer Dimension table. The customers have multiple sold-to addresses and multiple ship-to addresses. While the OLTP allows any Order to have any combination of sold-to and ship-to
Forums from same category
See also
more_less
Informations

0 Replies For the topic :
"ETL from 250+ disparate customer host systems"

This topic has been viewed 854 times.

Last message :
20/05/2010 at 19h32 by "bg4"