Modifying site's page content

[anton_k]

Hi!
I'm new to Alfresco, and I have a task to add a simple table at the bottom of the site page. The table should contain some data from the MS SQL database (not connected with Alfresco). (Installed Alfresco version: 4.2.0).

I've started from Alfresco Dev Guide and docs.alfresco.com, so I thought my issue could be solved using web scripts or server-sided java scripts. But I don't clearly understand how exactly should I operate with such tools: should I use eclipse IDE and Alfresco Maven SDK to build an extension, or just a simple .js file, which I will load using Alfresco Explorer, etc?
Appreciate any help.

[rjohnson]

There is an addon that allows you to link documents to an external database that may be of help. Check the addons site https://addons.alfresco.com/

If that doesn't work for you, you will need a dashlet that uses a grid (YUI datagrid is "built in to Alfresco") and you can populate it one of 2 ways:-

1. Write a Java backed webscript that extracts the data from your database.
2. Use a JavaScript webscript that extracts the data from your database using an AJAX call from the browser.

Option 2 may well give you a cross site scripting error so if you want to use AJAX to load the data you may well need to write a the Java backed webscript in option 1 anyway.