Re: MSSQL - DB2 Connectivity

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 11:39:41 -0700

I worked on one where we maintained a subset of the AS400
data in a SQL Server database. More data mart like than data
warehouse though. Integrating with the AS400 is doable. If
you are using Client Access, make sure that the CA installed
on the SQL Server box is kept up to date with the CA
patches.

-Sue

On Thu, 16 Dec 2004 00:22:17 -0600, "Erich Kolb"
<ekolb@kolbsoft.com> wrote:

>We are planning to start warehousing some of the data that currently resides
>on an as400 (using DB2) on a MSSQL 2000 server. Has anyone monitoring this
>group gone through such a project?
>

Relevant Pages

  • Connection Issues
    ... warehouse. ... OLAP cube into the Analysis Services Processing Task ... I am able to use the database in ... I am running SQL server 2000 with service pack 3a, ...
    (microsoft.public.sqlserver.dts)
  • Re: Access in wireless PDA scanner
    ... Access doesn't work with mobile devices ... you need to use SQL Server ... operations in a tiny warehouse of a friend of mine. ...
    (microsoft.public.access.devtoolkits)
  • reporting advice
    ... I am using SQL Server 2005 Standard Sp2 ... I am looking at creating a data warehouse where our OLTP and Archival ... thinking of using transactional replication to feed from the OLTP ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: forms authentication and roles
    ... > I am integrating forms authentication in a web app which authenticates ... > users who are listed in a SQL Server table. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Good Book on Datawarehousing with SqlServer?
    ... Can anyone recommend a good book on designing and implementing a data ... warehouse using sql server specifically? ... one that stands-out? ...
    (microsoft.public.sqlserver.datawarehouse)