require "java" require "rubygems" require "sequel" require "sqljdbc4.jar" #this files path may need to be relevate to file location DB = Sequel.connect( :adapter => "jdbc", :url => "jdbc:sqlserver://doric-server5;database=ADCData_Doric;integratedSecurity=true" # This is using integrated security, might want to pass username and password # More Info at http://sequel.rubyforge.org/rdoc/files/doc/opening_databases_rdoc.html ) the_table = DB[:the_table_name.identifier] puts the_table.to_csv