Fig. IBM AS/400 data can be connected to and synchronized with almost any other data sources. SharePoint or Office 365 is just an example.
If you have an AS/400 database table query like shown below, no problem to connect to the Microsoft Cloud with the following steps.
Fig. IBM AS/400 table query that returns salary of employees with department information (as a sample).
This is not a free download, but licensed with AS/400 software. You can just download the service pack on website. Use the 32-bit driver for the 32-bit Cloud Connector ot the 64-bit driver for 64-bit Cloud Connector.
With the OLEDB provider installed, it is easy to configure your data source in the Cloud Connector.
Fig. The data connection is configured with two simple settings, the connection string, and the query statement.
Note that the primary key should be automatically detected, but it may be necessary to specify a primary key if the data is not transfering correctly.
You can setup synchronization options in the Cloud Connector, such as:
- Uni-directional, bi-directional (access rights required)
- Field / column mapping with auto mapping
- Set sync schedule interval
After first sync, the SharePoint side should look like this:
Fig. Data destination with AS/400 data (SharePoint 2010 on-premises in this example).
In this example, SharePoint 2010 on-premises was used as data destination. But SharePoint 2013/16, Office 365 / SharePoint Online can be used in the same way.
On the SharePoint side all features are available:
- List views
- Managed Metadata and other additional (non-mapped) columns
- Change notifications per email and RSS
- Workflows on external data change
- Mobile and offline access (e.g. using Outlook)
SharePoint users do not need any access to IBM AS/400.
The Layer2 Cloud Connector closes many gaps and fixes issues that still exist with the Microsoft Cloud integration out-of-the-box. You can additionally connect the AS/400 source to almost any other data sources, like Azure, CRM Online, other databases, etc.