Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

AS400 and sharepoint integration

  Asked By: Stella    Date: Jun 07    Category: Sharepoint    Views: 3424

Has anyone done with pulling data from AS400 into sharepoint portal? any help?



8 Answers Found

Answer #1    Answered By: Vinay Thakur     Answered On: Jun 07

We use Microsoft HIS 2004 Ole DB driver to get to AS400 data. Then
present the data  in a web part Portal. There is no easy to use
interface to AS400 table. We had to use the native field name in AS400
to write our query so we had the AS400 programmer walk us through the
table field name.

The driver is slow at first connection (8 seconds in my WAN) but it got
faster (4 seconds) after that.

Answer #2    Answered By: Osvaldo Winters     Answered On: Jun 07

Is that with MOSS07?

Are you using a BDC?

Answer #3    Answered By: Alisha Itagi     Answered On: Jun 07

No. It is the SharePoint Portal 2003.

I am not sure what is "BDC" that you are referring to; I don't think so
but please let me know what BDC is.

Answer #4    Answered By: Brianna Olson     Answered On: Jun 07

MOSS07 Enterprise has a Business data  Catalog where one can configure
connections to various databases. These connections are then available
for various functions of SharePoint to consume.

Answer #5    Answered By: Allyson Burgess     Answered On: Jun 07

Can BDC do regardless of any types of DB? This was my question, have anyone done
that using BDC with AS400?

Answer #6    Answered By: Faith Delgado     Answered On: Jun 07

I would suggest that you check out the following which will more than likely
answer 95% of your questions:


BDC's out of the box can more or less bring in data  from any data source.
There are several out of the box connectors that exist, however you will
have to author the metadata application definition more than likely to be
able to actually pull in any meaningful data.

In terms of if there is a BDC that is available for the AS400, can't say
that I know for sure. I would consult the aforementioned link and see if
you can find the information which you seek. If that doesn't work, I would
suggest Googling the topic for a while (or Live search, or Yahoo...).

Answer #7    Answered By: Elaine Mack     Answered On: Jun 07

No. I am not using Business data  Catalog (BDC) yet. I will migrate to
BDC once I move to MOSS 2007. I hope to eliminate some of the data
layer complexities that I am having at this time.

However, there might be another client cal that we have to purchase. I
think those are called "SharePoint Enterprise Cal" which we do not
currently have.

Answer #8    Answered By: Baiju Hoskeri     Answered On: Jun 07

More than likely you are correct. The Enterprise CAL for SharePoint carries
a hefty price, but if you've got LOB applications that you want to integrate
into a single interface, I would definitely consider it. Otherwise you're
going to end up writing custom web parts to draw the information in which of
course incurs cost.

Didn't find what you were looking for? Find more on AS400 and sharepoint integration Or get search suggestion and latest updates.