ActiveWarehouse Discuss

Contact owners and managers

1–30 of 139

ActiveWarehouse discussion group - see http://www.activewarehouse.info for latest releases.

How to get started:

- read the manual (albeit it's not up to date - patches welcome!)

- read the rdoc (especially processor/transform - patches welcome too!)

- clone, run and dive into the activewarehouse-etl-sample

- read the source code (this is where you'll learn the most)

- leave questions here when you're stuck! (please do - we love to know when something is broken or not obvious)

Recommended books:

- aw-etl is based on the principles described in the Datawarehouse ETL Toolkit

- if you want to create a datawarehouse, read the Datawarehouse Toolkit

0 selected

amit kolariya

4/20/15

resolve_hash_connection': database configuration does not specify adapter (ActiveRecord::AdapterNotSpecified)

When i am trying to run the activewarehouse-etl and i am getting the error bundle exec etl etl/

unread,

resolve_hash_connection': database configuration does not specify adapter (ActiveRecord::AdapterNotSpecified)

When i am trying to run the activewarehouse-etl and i am getting the error bundle exec etl etl/

4/20/15

amit kolariya

4/20/15

`resolve_hash_connection': database configuration does not specify adapter (ActiveRecord::AdapterNotSpecified)

Hi, I am using gem 'activewarehouse-etl', '1.0.0' gem , but on running .ctl file the

unread,

`resolve_hash_connection': database configuration does not specify adapter (ActiveRecord::AdapterNotSpecified)

Hi, I am using gem 'activewarehouse-etl', '1.0.0' gem , but on running .ctl file the

4/20/15

Thibaut Barrère, Fabio Mendes4

8/14/14

Maintainer wanted for ActiveWarehouse-ETL!

I would like to contribute to this project. I like where you guys are going with it. However, from

unread,

Maintainer wanted for ActiveWarehouse-ETL!

I would like to contribute to this project. I like where you guys are going with it. However, from

8/14/14

Yves-Eric Martin, Thibaut Barrère7

7/10/14

Timezone for :new_records_only

Thank you :-) -- Thibaut

unread,

Timezone for :new_records_only

Thank you :-) -- Thibaut

7/10/14

Alejandro Carmona

4/3/14

RDoc is not working at this moment.

I was trying to check the RDoc for the activewarehouse-etl but at this moment is not available. Last

unread,

RDoc is not working at this moment.

I was trying to check the RDoc for the activewarehouse-etl but at this moment is not available. Last

4/3/14

Paul nop

10/4/13

undefined_method 'postgresql_connection'

Hi. I`m trying to run activewarehouse-etl and i`m getting error: Starting ETL process initializing

unread,

undefined_method 'postgresql_connection'

Hi. I`m trying to run activewarehouse-etl and i`m getting error: Starting ETL process initializing

10/4/13

Oren Mazor, … Oren Mazor3

4/13/13

multithread ETL

Hey Raimonds, Small world! we used your mondrian-olap library for a while, but then had to step away

unread,

multithread ETL

Hey Raimonds, Small world! we used your mondrian-olap library for a while, but then had to step away

4/13/13

Justin MacCarthy, Thibaut Barrère2

4/12/13

Using Activewarehouse-etl on a rails 2 project

Hello Justin! based on what is seen here: - https://rubygems.org/gems/activewarehouse-etl - https://

unread,

Using Activewarehouse-etl on a rails 2 project

Hello Justin! based on what is seen here: - https://rubygems.org/gems/activewarehouse-etl - https://

4/12/13

Anthony Eden

3/28/13

Fwd: Mysql2 pull request for rails_sql_views

All, I received this yesterday. Useful? If so then could someone merge it into activewarehouse/

unread,

Fwd: Mysql2 pull request for rails_sql_views

All, I received this yesterday. Useful? If so then could someone merge it into activewarehouse/

3/28/13

sk, … Thibaut Barrère16

2/6/13

how to use etl in delayed_job

Hi Oren! thanks for sharing! On threading: I didn't check, but thread-safety is very unlikely;

unread,

how to use etl in delayed_job

Hi Oren! thanks for sharing! On threading: I didn't check, but thread-safety is very unlikely;

2/6/13

Oren Mazor, Thibaut Barrère3

1/16/13

testing ETL tasks

Hey Thibaut, I've set up some simple rspec tests that go something like: - load known fixtures

unread,

testing ETL tasks

Hey Thibaut, I've set up some simple rspec tests that go something like: - load known fixtures

1/16/13

Chris Roberts, … Thibaut Barrère6

1/9/13

Re: Rails 3 NameError (uninitialized constant ETL::Engine)

> Although I'm not sure yet if i get the full use of the rails environment in my control files

unread,

Re: Rails 3 NameError (uninitialized constant ETL::Engine)

> Although I'm not sure yet if i get the full use of the rails environment in my control files

1/9/13

Henry Molina, Thibaut Barrère2

12/21/12

Destination file name based in field content

Hello Henry, Is there a way to set the destination "variable"? destination :out, { :file =

unread,

Destination file name based in field content

Hello Henry, Is there a way to set the destination "variable"? destination :out, { :file =

12/21/12

Oren Mazor

12/7/12

multi-tenancy with ETL

hey all, I've gotten my data importing quite nicely now and its working great. I'd like to

unread,

multi-tenancy with ETL

hey all, I've gotten my data importing quite nicely now and its working great. I'd like to

12/7/12

Thibaut Barrère, Andrew Kuklewicz3

12/4/12

Considering deprecations: what do you think?

Hi Andrew! I'll start with "mysql2" and AR 3+ then, to wait a bit for 1.9.3 :-) Thanks

unread,

Considering deprecations: what do you think?

Hi Andrew! I'll start with "mysql2" and AR 3+ then, to wait a bit for 1.9.3 :-) Thanks

12/4/12

Eric Budd, Thibaut Barrère2

11/29/12

Merging multiple data sources

Hello Eric! Welcome onboard :-) > In my ctl file, I've tried adding two sources. This works,

unread,

Merging multiple data sources

Hello Eric! Welcome onboard :-) > In my ctl file, I've tried adding two sources. This works,

11/29/12

Emmanuel, Thibaut Barrère7

10/26/12

Question around SCD

More things to watch out for. If you put a field from the input that is not coming from the database

unread,

Question around SCD

More things to watch out for. If you put a field from the input that is not coming from the database

10/26/12

Emmanuel, Thibaut Barrère6

10/18/12

Job dependencies

or Redis Mutex :) But for now same machine. Multiple if perf will struggle on the future ;) On

unread,

Job dependencies

or Redis Mutex :) But for now same machine. Multiple if perf will struggle on the future ;) On

10/18/12

Emmanuel, … Andrew Kuklewicz13

10/18/12

Insert/Updates only

I do bulk updates from files -> mysql, and use the insert or replace capability in mysql. http://

unread,

Insert/Updates only

I do bulk updates from files -> mysql, and use the insert or replace capability in mysql. http://

10/18/12

Henry Molina, Andrew Kuklewicz2

10/17/12

Problem with ibm db

Can you provide the connection info for the db source that uses the ibm_db in the .ctl file that is

unread,

Problem with ibm db

Can you provide the connection info for the db source that uses the ibm_db in the .ctl file that is

10/17/12

stellard, Thibaut Barrère4

10/10/12

Add Single Row to Beginning of pipeline.

> This is perfect. I did not realise you could have multiple sources per control file. Thanks

unread,

Add Single Row to Beginning of pipeline.

> This is perfect. I did not realise you could have multiple sources per control file. Thanks

10/10/12

Emmanuel, Thibaut Barrère2

10/8/12

Beginner questions !

Hello Emmanuel, here is what I can say - this is a bit of braindump so beware! 1) does bulk import

unread,

Beginner questions !

Hello Emmanuel, here is what I can say - this is a bit of braindump so beware! 1) does bulk import

10/8/12

Giovanni Messina, … Thibaut Barrère15

10/8/12

trouble with bulk_import and postgresql sequences

Hello Jamie, > Could you give me an example of how you did that temp_table manually? > I know

unread,

trouble with bulk_import and postgresql sequences

Hello Jamie, > Could you give me an example of how you did that temp_table manually? > I know

10/8/12

Jamie van Dyke, Thibaut Barrère4

10/8/12

Documentation looks stalled

> No problem, you've done a great job with the code, loved your Rulu talk too and that's

unread,

Documentation looks stalled

> No problem, you've done a great job with the code, loved your Rulu talk too and that's

10/8/12

Jayaram Sudheer, Thibaut Barrère4

10/2/12

can we write model validations for the data in etl process

yeah if that validation fails then it should raise an error and the process should stopped completely

unread,

can we write model validations for the data in etl process

yeah if that validation fails then it should raise an error and the process should stopped completely

10/2/12

sk, Thibaut Barrère2

9/27/12

ETL process file upload

Looks like this one was double-posted. Please see my other answer - and please try not to double post

unread,

ETL process file upload

Looks like this one was double-posted. Please see my other answer - and please try not to double post

9/27/12

sk, Thibaut Barrère2

9/27/12

Can anyone help me...

Hello mysterious visitor, But my requirement is to create a view page in that if any user uploading

unread,

Can anyone help me...

Hello mysterious visitor, But my requirement is to create a view page in that if any user uploading

9/27/12

Jayaram Sudheer, Thibaut Barrère2

9/27/12

i got the following error when dumping data from database to a file

Hello, the answer is in the guide: search for ":order": https://github.com/gmgp/

unread,

i got the following error when dumping data from database to a file

Hello, the answer is in the guide: search for ":order": https://github.com/gmgp/

9/27/12

Jayaram Sudheer, Thibaut Barrère4

9/27/12

encryption of password using tranformations

Hi, Thanks but is n't work for me my code is like this, my field name is password, and the

unread,

encryption of password using tranformations

Hi, Thanks but is n't work for me my code is like this, my field name is password, and the

9/27/12

Jayaram Sudheer, Thibaut Barrère2

9/24/12

etl process from the front end

Hello, quick reply from phone: unless your system has very few users/requests or the etl is very

unread,

etl process from the front end

Hello, quick reply from phone: unless your system has very few users/requests or the etl is very

9/24/12