A little background:
We have an IBM iSeries v7.1 I believe that houses our ERP system. The ERP system has a DB2 database to house all of the data.
We’re running SharePoint 2013 Enterprise on Server 2012 with a SQL 2012 backend.
We’d like to be able to do a few things with this data in SharePoint including:
1. Create site columns based on columns in the ERP system with real time data not a point in time copy of the data.
2. Create reports based on live data through BCS to automate what is now a manual process.
3. Create Metadata terms based on some of the data in the ERP system.
I know there are some products out there that will do some of this, but I’m wondering if we really need these products or if this is something that SharePoint does natively?
Hi Amancio,
Did you ever got this working? I am interested to do the same Jon SharePoint 2013 and would like to know if you got yours working.
Regards
Bhuti
Hi Michael, I’m trying to find a solution myself. I followed the SQL Linked Server path and I guess I’m almost there 😉
I’ve created a linked server with the help of my DBA administrator:
With the following format of the connection string:
Data Source=[datasource];User ID=[user];Initial Catalog=[catalog];Provider=DB2OLEDB;Persist Security Info=True;Network Address=[ip-address];Package Collection=QGPL;Default Schema=LGPDTA;Default Qualifier=LGPDTA;DBMS Platform=DB2/AS400;Process Binary as Character=True;
No I need more input regarding the connection from SharePoint Designer to the Linked Server. It’s not working the same as making a connection to normal SQL DB as you would by creating an external contenttype.
Do you have any progress?
Regards, Amancio
