Hello,
Our company is looking to develop all future web sites using ruby on
rails. I am on a mac running leopard but the data needed for the back
end of our websites is in sql server. I thought activewarehouse would
be a logical way to go since we are using ruby on rails(ror). We are
going to be grabbing data on a continuous basis from sql server and
putting it in mysql which will power the ror sites.
After a bit of tinkering I was able to get aw-etl to actually work
using both a csv file and mysql db as a source and a mysql db as a
destination. However I cannot connect to sql server. Below is the
error I get when running my control file.
gunner-gellers-mac-pro:etl gunnergeller$ etl etl_test_db_sql2.ctl
Using AdapterExtensions
Starting ETL process
initializing ETL engine
Processing etl_test_db_sql2.ctl
Source: localhost/etl_development/test
/usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/
base.rb:1532:in `method_missing': undefined method
`sqlserver_connection' for #<Class:0x1121e88> (NoMethodError)
from /usr/local/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/
bin/../lib/etl/engine.rb:207:in `send'
.......
Here is my database.yml file:
etl_sql:
adapter: sqlserver
mode: odbc
dsn: DRIVER=/opt/local/lib/
libtdsodbc
.so
;TDS_Version
=8.0;SERVER=192.168.xxx.xxx;DATABASE=db;Port=1433;uid=un;pwd=pw;
and my control file:
.....
destination :out, {
:type => :database,
:database => 'etl_development',
:target => 'etl_sql',
:table => 'test2'
},
{
:order => [:id, :first_name, :last_name, :email, :loaded_at]
}
....
I can connect to sql server in my rails app using the exact same
database.yml file. Also if I use mysql as a destination everything
works fine too. Has anyone tried to use aw-etl with sql server? Or
does anyone know what I need to fix? The error says method missing,
which makes me think I haven't installed something, but the fact that
I can connect in my rails app just confuses things.
Any help is appreciated. Thanks Gunner.
_______________________________________________
Activewarehouse-discuss mailing list
Activewarehouse-discuss@rubyforge.org
http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
