search for: etl

...called RedMine created with Rails, in order to have a sort of "separate" interface (not the same as the app) for one of the departments (that interact with the app) to interact with it and generate some different reports based on the same data. I don''t know much about either (ETL and Rest), all I know is that ETL seems to NEED a database connection and Rest uses HTTP petitions to get data and the web service returns XML. What I''m wondering if It''s possible to "consume" a web service with ETL? It seems to me that is not the purpose of ETL, but...

I am trying to load conversion data into a postgresql database using activewarehouse-etl. I can create a flat file output from the conversion data without problem. However, when I try to load into the table using the information contained in config/database.yml I see this error: /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ base.rb:1959:in `method_missing'&...

Saludos a todos.Estoy en un proceso de carga de información a un DWH, y estoy validando que los ETLs estén correctos.Tengo datos de los transaccionales (T) y de la nueva base de datos (B).Mi objetivo es validar que los procesos de limpieza de datos y corrección, estén bien.tengo 2 columnas en un data.frame, la una es el nombre del cliente en el transaccional (T) y en la otra columna, el nombre de...

I''m working on an app that uses info from a government database. For a variety of reasons (not the least of which is that their database is in MS Access), I can''t simply write a wrapper around the legacy database. Instead, we''re looking to have an "import" script in the Rails environment (it''s fine if it''s run from the server and through the

.../var/log/samba/%m.log log level = 10 client use spnego = yes idmap config * : backend = tdb idmap config * : range = 1-199999 idmap config DOMAIN : backend = sss idmap config DOMAIN : range = 200000-2147483647 [share1] comment = NMS Maximo ETL Directory path = /opt/smbshare guest ok = no browseable = No read only = No inherit acls = Yes I have tried running it with many options and with and without winbind running. Not sure if winbind is needed. When I run it the output of the "systemctl st...

...make data management an ever-greater differentiator for Oceanus by: Maintaining our dozens of data sources and import schedules and processes to deliver 100% reliability and integrity, even in the face of poor-quality source data Applying innovation, intelligence, and heuristic approaches to our ETL rather than standard, fixed brute-force rules Continuously enhancing our technology platform and toolsets as new problems arise: building and buying when appropriate Becoming a subject matter expert in the data itself, to apply better semantic checks and structure the data more intelligently than...

Dear R People: I am using qcc for a quality control class. I have used qcc with type "xbar.one" for individuals but cannot determine how to plot a moving range control chart. Has anyone done that, please? Thanks, Erin -- Erin Hodgess Associate Professor Department of Computer and Mathematical Sciences University of Houston - Downtown mailto: erinm.hodgess at gmail.com

Hi, I am trying to copy the directory structure only from the remote UNIX box onto the box from which Im executing the rsync. This is what I tried: rsync -av --include '*/' --exclude '*' tashaikh@remotebox:/dw/etl/ home/ prod/log/ /export/home/tashaikh/auto/log The above keeps on executing without returning any result. I have tried to copy directory structure from another directory on the same machine itself . The one shown below works: rsync -av --include '*/' --exclude '*' srcdir/ destdir...

Hi All, We have a product that performs ETL on files and finally load the database. We want to give the web based interface displaying graphs (that are generated using R-project forcasting) from this database. But R-Project is stand alone desktop based software and it takes commands at command line to show graphs. Any one has any idea how t...

...ta warehouses. It provides classes for modelling facts, dimensions and cubes. ActiveWarehouse will automatically build and populate persistent aggregate tables so that you don''t have to. It also provides a report class for persistent report configurations. ActiveWarehouse also includes an ETL component, currently at version 0.3.0, which can be used to load data into the warehouse. The ETL component provides fixed-width, delimited and XML parsing, file and data inputs and outputs and support for bulk loading of data (currently only MySQL). The article covers the entire process including...

Hello, I''m having trouble with transactions with rails 3.0.3 and mysql 5. I''d like to import data etl-batch-style: class Job < ActiveRecord::Base # ... def perform_etl connection.transaction do extract # some connection.execute / job.update_attribute stuff transform # some connection.execute / job.update_attribute stuff end end #... end I''m using InnoDB as...

...never got any connection. Has someone an idea what i could try to find out why dovecot did not switch to server1.tld? Best regards Matthias Egger -- Matthias Egger ETH Zurich Department of Information Technology maegger at ee.ethz.ch and Electrical Engineering IT Support Group (ISG.EE), ETL/F/24.1 Phone +41 (0)44 632 03 90 Physikstrasse 3, CH-8092 Zurich Fax +41 (0)44 632 11 95 -------------- next part -------------- A non-text attachment was scrubbed... Name: smime.p7s Type: application/pkcs7-signature Size: 4099 bytes Desc: S/MIME Cryptographic Signature URL...

...q=5, idx_msgs=224) Any idea of what this could be? The user is reporting that he is seeing multiple times the same mails and that the new flag is not being unset after he reads a mail. Cheers David -- David Schweikert | phone: +41 44 632 7019 System manager ISG.EE | walk: ETH Zentrum, ETL F24.1 ETH Zurich, Switzerland | web: http://people.ee.ethz.ch/dws

Buenas, Quiero hacer una ingesta de datos en una base de datos de un servidor. El proceso es hacer una consulta en la base de datos, que me dice uqe columnas tengo que coger. Una vez hecha dicha consulta, abrir un csv, coger las columnas que me indicaba esa base de datos y subir el dato concreto del csv a una base de datos. Estoy pensando en usar Apache Flume o similar, pero es en un servidor

...de progreso tcltk , me funciona perfectamente y además la barra de progreso es más bonita ? Ahora me entra la curiosidad malsana de saber porque con la barra de windows no sale la barrra y con tcltk si que aparece. Carlos: No habia oido hablar de ese paquete pero en cuanto termine con los ETL que tengo pendientes voy a empollarme la web del paquete que me has enviado porque seguro que agiliza muchisimo todos estos procesos. Muchas gracias a los dos por la variedad y calidad de las soluciones José Luis Gilsanz Gómez Estadística Departamento Técnico Entidades Financieras...

...-daewoo-mincho-medium-r-normal--16-120-100-100-c-160-ksc5601.1987-0' are not working correctly now. fixme:font:LFD_InitFontInfo DBCS fonts like '-daewoo-mincho-medium-r-normal--24-170-100-100-c-240-ksc5601.1987-0' are not working correctly now. fixme:font:LFD_InitFontInfo font '-etl-fixed-medium-r-normal--16-120-100-100-m-80-bitmap.8x16-0' has unknown registry 'bitmap.8x16' and character encoding '0' fixme:font:LFD_InitFontInfo DBCS fonts like '-isas-fangsong ti-medium-r-normal--16-160-72-72-c-160-gb2312.1980-0' are not working correctly now. fix...

I am working on and will be publicly showing ActiveRecord some love around the time of the RubyConf*MI [1] in late August. My main focus is getting AR to better handle inserts, updates and merges when working large sets of data. It can improve improve performance by 400% to 600% in preliminary benchmarks. I am coding this in a way so it can be patched to AR easily, and with that in mind

On Tue, Nov 04, 2014 at 12:38:02PM +0100, Matthias Egger wrote: > Has someone of you just found any kind of solution to this problem? We have been running some days with patches 31262a892ba7 and 80ed82a93c1a from http://hg.dovecot.org/dovecot-2.2/ They are working fine, handling the previously paniced situations smoothly. Thanks again to the folks at dovecot.org! hmk

...hly. > Thanks again to the folks at dovecot.org! Thank you for sharing this. I will give today or tomorrow a look at these patches. Matthias -- Matthias Egger ETH Zurich Department of Information Technology maegger at ee.ethz.ch and Electrical Engineering IT Support Group (ISG.EE), ETL/F/24.1 Phone +41 (0)44 632 03 90 Physikstrasse 3, CH-8092 Zurich Fax +41 (0)44 632 11 95 -------------- next part -------------- A non-text attachment was scrubbed... Name: smime.p7s Type: application/pkcs7-signature Size: 4099 bytes Desc: S/MIME Cryptographic Signature URL...

...? Experience in ? Microsoft SQL What You Will Learn: ? Statistical ? OLAP concepts ? Microsoft SQL ? Implementing techniques, including audience extractions and manipulation, and program ? CRM systems ? Reporting tools ? ETL (Extraction, Please note that this is a three-month internship that may lead to a permanent position. Submit your resume to hr at loyaltymatrix.com with "[R] Internship" in the subject heading. --------------------- References 1. 3D"http://www.craigslist.org/"...