Has anyone useda REST-based approach for ETL / Datawarehousing operations? In other words, invoking ETL and OLAP / Database refresh jobs through REST webservices calls:
I am working on a data warehousing project where several systems are loading data into a staging area for subsequent processing.Each table has a \"loadId\" column which is a foreign key against the \"
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing
I have an ETL that is importing tab开发者_如何学Cles from Oracle to SQL 2008 using the OLEDB FastLoad.
I have a folder where files are going to be dropped for importing into my data warehouse. \\\\server\\share\\loading_area
I am working on a new Datawarehouse trying to import a number of d开发者_JAVA百科ifferent format files from a number of different providers.
For my job I do very big imports of (product) data. Recently we started using SSIS and it sure works better then custom .net import tools. Still after 3 projects we figured out it\'s more efficient to
I\'m looki开发者_如何学Cng for an ETL solution that we can create a configure by hand and then deploy to run autonomously. This is basic transformation, it need not be feature heavy. Key points would
I have click stream data such as referring URL, top landing pages, top exit pages and metrics such as page views, number开发者_Go百科 of visits, bounces all in Google Analytics. There is no database y
I have a flat file that looks something like this: junk I don\'t care about\\n \\n columns names\\n val1val2va开发者_如何学Gol3\\n