Tag Info

Hot answers tagged

5

Another option that you can look into is the Business Data Catalog. While this is more complicated it does allow you to have a SharePoint view of the data. The downside to this is that it does require the Enterprise edition and pretty advanced skills to get the BDC configured to point to your custom database. Since you said you are not a developer, I would ...


1

I would think you could: Create an Excel spreadsheet that has the SQL query to the database Execute the query and do a Copy Values copy in Excel and paste that to a new workbook Import that workbook when creating the Sharepoint list For displaying data live using a query, you need the Sharepoint Designer and you add a Data View to the list. See: ...


1

If you know, you can go to MSSQL server and write your SQL query to fetch data from CRM database. After this, you can use Sharepint designer, and use Business data connectivity service


1

I don't know how to do it using SharePoint Designer, but here's how you can do it in a browser: navigate to the Title, Description, and Icon page (Site Actions > Site Settings > Title, description, and icon), enter address of the logo in the URL field.


1

If you have any 3rd party components, such as web parts, make sure that they are not limited to 32bit operating systems.


1

It looks like you are getting an error when the SQL command is executed against the database. (OracleCommand.Execute) is the eror line. The error says that it does not expect the "from" statement in your "select * from" I would suspect there is some extra string data in the command string being passed.


1

I took some time investigating this. In SP 2010 it is easy to import a table as an EXTERNAL SharePoint list. The data in the db and the list and is syncronized dynamically when someone modifies the table in the DB or the List in SP. But trying to create a workflow that writes data to and external SharePoint list...well you can do it but it involves a ...



Only top voted, non community-wiki answers of a minimum length are eligible