I am dump about ODI Tool, but i开发者_开发知识库 just heard that we can use ODI for data moving from SQL Server 2005 to PostgreSQL easily can any one tell me how to do that (Like steps need to be foll
I\'ve been hanging around SO for a couple of days found the community great! I\'m certain that someone can give me an opinion on my question:
I\'m fully convinced that a significant part of the work I\'m doing falls into this domain of ETL, but I didn\'t even know the term existed before 3 months ago. I\'ve found SSIS to be a bit of a misma
My company needs to migrate data from a Taleo system to a new HR system. A little research suggests that traditional ETL may not work against t开发者_如何学运维he Taleo cloud based system, but I don\
Is there a开发者_StackOverflow中文版n ETL for MongoDB ?...Pentaho Data Integration supports MongoDB (See the documentation http://wiki.pentaho.com/display/EAI/Pentaho+Data+Integration+Steps).
We get daily files that need to be loaded into our database. The files will get delivered on a separate server than the database. Which one of the 2 approaches are better for the ETL from a performanc
I\'m trying to get a good definition of realtime, near realtime and batch?I am not talking about sync and async although to me, they are different dimensions.Here is what I\'m thinking
I have been looking at several deployment strategies for SSIS and wondering which one would be easiest to maintain.I have been leaning toward using SQL Se开发者_StackOverflowrver Configurations to hou
I\'m trying to take an existing column and parse each row for certain words in a string, i.e. Sheet, Page, Card, and based on that word (only one instance of one of these words is in a row) populate a
I have an ETL application which extracts data from a source database (for which I only have read access) and loads it into my SQL Server database.The extract is run using ODBC queries from a C# applic