IDS Forum

RE: Using dbaccess remotely on Windows Server

Posted By: Alexandre Marini
Date: Thursday, 23 May 2013, at 2:19 p.m.

In Response To: Using dbaccess remotely on Windows Server (MARK HEPTINSTALL)

Hello.
One option would be using a shared filesystem, and run a cron job in linux server, using external table feature. That should be great for bigger tables, but it is not so easy as a simple "unload to /dir/file select * from table", that can also be run into a cron job, on linux side.

If you don´t want to share a filesystem, there could be used an ftp transfer, or some other way (it mostly depends on your operational systems and frontends, from Informix there is no much to do).

Hope it helps.
Regards.

Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70

IBM Information Management Informix Technical Professional

IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant

> To: ids@iiug.org
> From: djphatic@gmail.com
> Subject: Using dbaccess remotely on Windows Server [30325]
> Date: Thu, 23 May 2013 13:21:34 -0400
>
> We are currently in the process of upgrading one of our core applications
> which also involves moving from DB2 to Informix 11.5.
> There is a requirement that we extract data from this Informix database once
> nightly to a staging area on a MS SQL Server which is used to produce various
> management reports and data warehouse extracts.
>
> I've previously used the DB2 IBM iAccess File Transfer Utility for this which
> extracts the contents of a table into a delimited file (and various other
> methods) which is then imported into our MS SQL Server via a single
> Integration Services package. My understanding is that the dbaccess Informix
> tool will allow me to unload table contents into a delimited file by issuing
> the appropriate SQL statements.
>
> We have the 64-bit Informix Client SDK installed on our Windows server where
> the MS SQL Server instance is hosted. However I am unclear on what I should be
> configuring on the Windows server and also the Informix server so I can use
> the dbaccess tool remotely to unload a series of tables into delimited files
> onto the Windows server.
>
> We already have linked server connections created in MS SQL Server which could
> be used for extracting the data but my concern is that this will not scale and
> SQL Server Integration will easily out perform the linked servers method.
>
> I have very limited knowledge of Informix along with its setup and
> configuration. Do you have any suggestions on what details I need to acquire
> or whether this is even possible to do?
>
> Any help is greatly appreciated.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

• Using dbaccess remotely on Windows Server
  MARK HEPTINSTALL -- Thursday, 23 May 2013, at 1:21 p.m.
  • Re: Using dbaccess remotely on Windows Server
    Art Kagel -- Thursday, 23 May 2013, at 1:32 p.m.
    • Re: Using dbaccess remotely on Windows Server
      MARK HEPTINSTALL -- Thursday, 23 May 2013, at 1:46 p.m.
      • Re: Using dbaccess remotely on Windows Server
        Art Kagel -- Thursday, 23 May 2013, at 3:01 p.m.
  • RE: Using dbaccess remotely on Windows Server
    Alexandre Marini -- Thursday, 23 May 2013, at 2:19 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.