database - data curation system and manual data management -



database - data curation system and manual data management -

i'm looking solution may exist; however, i'm unable identify name type of scheme , hence unable find one. hoping identify i'm looking for.

i have info get's manually , automatically curated. manually curated info updated , managed in excel or form of spreadsheet. automated scheme generates spreadsheets more manual curation. i'm looking rdbms based software solution allow info entry employees or curators create info schemas little db experience (using gui). in add-on can create schema changes , modifications info set. info can deployed number of sources triggers etl daemon fetch changes , persist destination source (staging, production, etc).

here requirements:

system should user friendly , accessible non-dba or non-programmer (friendly gui) system should allow users create , alter schemas in db system should have api developers can utilize automatically curate data system should have api developers can utilize write etl scripts fetch changes info (for quick updates , imports) bonus: scheme can allow users/curators deploy admin controlled sources

i think gives general image of i'm looking for. i'm sure kind of similar scheme must exist. principle of info warehouse , etl process not novel means.

does know kind of software/system i'm looking for?

a name or phrase can help me research systems server purpose.

bonus: know of "affordable" solutions?

we utilize automation / etl solution in workplace called foxtrot. i'm not in , utilize regularly; point , click write scripts automate sorts of things. believe there 2 flavors: 1 automates in windows , automates in windows , web. can find more here: http://www.enablesoft.com/foxtrot-automation-software/

database database-design spreadsheet rdbms data-warehouse

Comments

Post a Comment

Popular posts from this blog

xslt - DocBook 5 to PDF transform failing with error: "fo:flow" is missing child elements. Required content model: marker* -

xslt - DocBook 5 to PDF transform failing with error: "fo:flow" is missing child elements. Required content model: marker* - i've inherited doc publishing process takes docbook , builds html , pdf output, using apache fop both. project had been started, never completed. lots of tweaking, i've able of doc sets build (20+), except handful, , fail severe code 1 of these 2 conditions: "fo:flow" missing kid elements. required content model: marker* "fo:block" not valid kid of "fo:root" the xml output comes out of docbook , docbook-fop checks out well-formed. the fop error in 1 book, "endecagloss", example, points end of string: <fo:flow flow-name="xsl-region-body" start-indent="4pc" end-indent="0pt"/> here’s log output in case: [java] severe: javax.xml.transform.transformerexception: file:/scratch/publishing/hudson/jobs/build-main-endeca-documentation/workspace/serverdoc/w...
Read more

mediawiki - How do I insert tables inside infoboxes on Wikia pages? -

mediawiki - How do I insert tables inside infoboxes on Wikia pages? - i want insert tables in infoboxes. example, have proteinbox i've developed using infobox template (http://health-and-medicine.wikia.com/wiki/template:proteinbox), , fasta field big fit comfortably in proteinbox. hence collapsible table within box. this tried: {{infobox | row 1 = {| class = "mw-collapsible mw-collapsed wikitable" |- | <!-- table content --> |} }} your problem is, putting nested table within template. pipe characters ( | ) in table syntax collides pipe usage in templates. the commonly used hack around create template called template:! , containing pipe character, , utilize when need set tables, parser functions or other stuff using pipe characters, within templates. table (with every | replaced {{!}} ): {{{!}} {{!}}- {{!}} a1 {{!}} b1 {{!}}- {{!}} a2 {{!}} b2 {{!}}} ...the equivalent of {| |- | a1 | b1 |- | a2 | b2 |} furthermore, hav...
Read more

Local Service User Logged into Windows -

Local Service User Logged into Windows - i created windows service tracks app server user connected through load balancer. it retrieves user logged windows on machine, cross references active directory (ad) business relationship homecoming first name, lastly name , e-mail (for notification through website created project) there 1 scheme on network users remote system, vista system, reason returning values "local service" logged machine, it's weird , security guys impossible "local service" business relationship logged windows. here how user logged windows managementscope ms = new managementscope("\\\\.\\root\\cimv2"); objectquery query = new objectquery("select * win32_computersystem"); managementobjectsearcher searcher = new managementobjectsearcher(ms, query); foreach (managementobject mo in searcher.get()) { _username = mo["username"].tostring(); } // remove domain part username string[] usernameparts = _...
Read more