Show table in Sharepoint foundation 2010

wirtnix

Hello,

i want to create a panel-pc for our workers where they can view their working-shedules for the following week
i have a table in NAV-SQL-Server where all information is stored.
](*,)

is there a way to get those table data (eventually including filters on date ) into a sharepoint site?

i already tried the external data but it failed because i cannot store the user id and password to access to our NAV SQL-server