I have tried this before, but with no result, to actually get data from Dynamics NAV straight into Sharepoint using the BDC catalog. It seemed so easy, just create the ADF file and import it in Central Administration and youre ready to read from your business system. Not quite.. So today I did a new attempt using the BDC application from Microsoft (downloaded it here). I have tried the BDC Metaman before, but today I used this app which comes with the SDK:
Quite easy to install and setup and even enter the connection string:
I added the table I wanted data from and exported the xml file and imported it to Sharepoint. I got an error about the profile page:
Could not create profile page for Entity NaB Solutions AB$Contact. The error is: Cannot create a new connection to closed Web Part “g_f9c81dbd_bdf8_4935_a3f3_6558836696df”.
Went into my Sharepoint site and created a column that is of type Business Data and it was empty. Access? No, I’m the admin. I probably need to configure some more, and look into the error I got.
To be continued…