Sorry, I meant ETL (Extract Transform Load).
Yeah, I don't think our data or business needs are such that our reporting is much of a burden on our operational systems. I'm leaning toward having both operational and redundant/read-only tables in the same MySQL DB on the same server.
It will have an ETL layer, but I don't think I should call it a "data warehouse", per se.
Sounds like you think this...
snfctech
Last Activity: Dec 22 '09, 12:50 AM
Joined: Aug 11 '09
Location:
-
Thanks for youre reply, gits.
Which is precisely my quandary. Does it make sense to build the type of centralized DB I'm talking about, which has both a "warehouse-like" ELT component, and a basic ER schema for an active operational system making inserts, updates, etc.? If so, does it still make sense for me to study any traditional warehouse design principals (a la Kimball or Inmon)?
I still don't...Leave a comment:
-
multiple db connections vs. centralized/ redundant db
I have a project to create a dashboard that will connect to existing systems as well as create new features based on combining data from the existing systems. For example, the dashboard will be able to generate "orders" containing data merged from "members" (MS Access DB), "employees" (MySQL DB) and "products" (flat file), and there will also be new attributes particular to "orders."
... -
Thanks for your reply, Markus.
I'm actually starting to think that a web client/server paradigm is the best approach for my application for 3 main reasons:
- easy deployment
- easy updates
- faster UI development with web framework than with desktop library
The web2py project is looking like the most promising framework for my project, largely due to it's built-in multi-database/product handling.Leave a comment:
-
Hello, hexcoder. Thanks for your reply.
We believe that open source is the best approach for our organization. We have been plagued by licensing issues and an inability to modify and improve some of the closed source products we have been using. Plus, we are a Co-op, and believe that the cooperative approach of open source projects bests align with our business principals.Leave a comment:
-
integrated system dashboard - Python/Django? OOo Base? Other?
I'm about to start a fairly large project for a mid-sized business with a lot of integration with other systems (POS, accounting, website, inventory, purchasing, etc.) The purpose of the system is to try to reduce current data siloing and give employees role-based access to the specific data entry and reports they need, as well as to replace some manual and redundant business processes. The system needs to be cross-platform (Windows/Linux), open...
No activity results to display
Leave a comment: