Let’s build a data driven SQL presentation that get its information directly from a Microsoft SQL Server database. With DataPoint you can link your slides to a database and display real-time information on your slideshow or view the latest information on your slides when you just open the presentation.

Setting Up a Connection

Click the List button at the connections group of the DataPoint menu.

sql presentation list connections

Select the Microsoft SQL Server node in the tree and then click Add Connection.

sql-presentation-add-connection

Set the connection information; server, username, password, database. You will  get this information from your database administrator.

sql presentation log on as

We return to the connection overview and see that the new sql connection was added. Click the Rename button to change the description and click Enter. Then click the Add Query button to continue the creation of our SQL presentation.

sql-presentation-connection-added

We get a list of tables and views that are declared on the database. Alternatively, you can enter a custom SQL statement or enter a stored procedure call. Select the table you want to use on your slide.

sql-presentation-add-query

You can change the refresh rate. This is a timer that checks for new or updated data at the sql server. Click OK to close.

sql-presentation-preview-data

You can rename the query and you will find a preview of the selected data. You can also add other connections as well, pointing to other tables and views. Click OK to close this connections form.

Textbox Bindings

Draw some textboxes or tables on your slide(s).

sql presentation add slide and textboxes

Select the textbox and click DataPoint, Textbox. This opens the binding properties form of this textbox.

sql-presentation-link-textbox

From the comboboxes, select the data connection, the column and row number of the database field that you want to display here in this textbox. Repeat this step for all other textboxes that you want to link dynamically to the sql server database.

Start the Slideshow

Start the slideshow and DataPoint will check every 5 seconds for new updates. Whenever a change of data is detected, DataPoint will immediately update the linked textbox on your slide. Now you can update the information in your database and leave the slideshow running.

sql presentation slideshow

In this sample, we used some textboxes. But you can use other types of PowerPoint shapes like charts, tables, images etc., to display the latest information from the sql database.

Download your free data driven PowerPoint templates
Use DataPoint to link presentations to various data sources
Great Digital Signage software for playlists with images, videos and PowerPoint presentations
Download Free PowerPoint Templates - 237 slides in total

Download Free PowerPoint Templates - 237 slides in total

You will also be added to our mailing list to receive the latest news and updates from our team. Unsubscribe any time.

You have successfully subscribed. Look for the download link in the email you provided.

Free Video: 10 Secrets to Exceptional Presentations

Free Video: 10 Secrets to Exceptional Presentations

You will also be added to our presentations resource newsletter. Unsubscribe anytime

You have Successfully Subscribed!

PowerPoint Tips and Tricks

PowerPoint Tips and Tricks

Get instant access to the video and receive our regular presentation resource news

You have Successfully Subscribed!

Pin It on Pinterest

Share This