Query SQL Server from Linux

  • Is anyone running some type of ISQL / OSQL like application on Linux to query SQL Server databases? I have a batch process that executes from a Linux host (SUSE). The batch process interacts with UDB, Oracle and SQL Server 2008. I have ODBC drivers for SQL Server installed on the Linux host for use by our ETL tool (Informatica).

    I need a command line application that can (hopefully) use my existing ODBC drivers and allow me to connect to SQL Server to execute simple SQL scripts. I could also envision something connecting via JDBC. An Open Source application would be best, but not mandatory.

    Is anyone running a command line query tool for SQL Server from Linux?

  • Doesn't Informatica have a scripting option that makes use of its engine? I know Ab Initio does.

    Failing that follow this blog http://bytes.com/topic/sql-server/answers/534929-managing-ms-sql-linux

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply