Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Data "input" tool

4 posters

Go down

Data "input" tool Empty Data "input" tool

Post  MD Tue Apr 03, 2012 8:35 am

Hi,

I was wondering if anyone had suggestions for how get data into data warehouse, which isn't located in any "source systems". E.g. Marketing departement which to group products in specific ways (for reporting purposes).
At the moment we a using Excel-sheets, that we load in via an ETL-tool.

But I am looking for a more structured way to do this. Some kind of form-tool, using sharepoint etc.?
Would like to hear suggestions from anyone, who are not using the "Excel-solution".


Best regards
Morten
Denmark

MD

Posts : 1
Join date : 2012-04-03

Back to top Go down

Data "input" tool Empty Re: Data "input" tool

Post  ngalemmo Tue Apr 03, 2012 12:28 pm

MS Access?

If you do low volume data entry, you should still handle in an area separate from the data warehouse and use an etl process to apply it to the dw. This gives you control as to when data gets in an provides the ability to audit such updates, Giving free access to do direct updates that affect analysis results across the board is not a good idea,
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Data "input" tool Empty Re: Data "input" tool

Post  John Simon Tue Apr 03, 2012 11:24 pm

I'd go with SharePoint. It's built for that kind of thing.

John Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

http://jsimonbi.wordpress.com

Back to top Go down

Data "input" tool Empty Re: Data "input" tool

Post  hang Wed Apr 04, 2012 8:56 pm

It seems MS new Master Data Services serves the purpose as well.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

Back to top Go down

Data "input" tool Empty Re: Data "input" tool

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum