Solved

Create External Content Type in SharePoint Designer 2013 to DB2 server linked to SQL 2012

Posted on 2013-05-21
1
1,118 Views
Last Modified: 2013-05-22
I'm attempting to connect SharePoint 2013 Enterprise to some backend data on our IBM iSeries.

I linked the iSeries DB2 database to the SQL 2012 instance successfully and I can query data just fine from a SQL query prompt.

When I attempt to add a connection in SP Designer 2013 to the SQL 2012 server I've tried a database local to the server which works fine when I impersonate the user.  However when I enter [LinkedServer].[Catalog].[Database] in the Database field I get a login error.

When I look at the event logs I see that it's trying to connect to the master.db which tells me it doesn't know what to do with the that particular name string.

From what I've read this is possible but every example of connecting to a linked server always ends up showing how to connect to a local db not the linked server's db.

Is it possible or am I going to have to end up purchasing some additional software to make this work?
0
Comment
Question by:apa-IT
1 Comment
 

Accepted Solution

by:
apa-IT earned 0 total points
Comment Utility
I found a solution to this which caused me to go another route.

The 'free' solution is to create a local database with the data you need from the linked server.  However this duplicates data, duplicates storage costs and overall isn't a great solution.

There are other ways to do this via code but I opted to go with Layer2's Business Data List Connector.

It just works and I can call data on the fly in a list or create a custom list from a table if needed.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now