Full Sail Partners Blog
Understanding How Deltek Vision Utilizes FILESTREAM and TDM
As a Deltek Vision client, you may have heard the terms FILESTREAM and TDM thrown around and may be wondering what they are. To clarify, FILESTREAM and TDM are two different things but work hand in hand to provide the desired functionality in Vision.

FILESTREAM is a SQL technology introduced in SQL Server 2008 to facilitate the storing and management of unstructured or Binary Large OBject (BLOB) data (image files, word documents, pdf documents, etc.), and ensures transactional consistency between the unstructured data stored in the network file system and the structured data stored in the tables.
Transactional Document Management is a Deltek Vision feature that facilitates the uploading of supporting documents (Expense Receipts, Vendor and Sub-Consultant invoices, etc.) and the ability to attach those supporting documents to transactions within Vision. With supporting documents uploaded to Vision it also gives the ability to easily review and print those supporting documents automatically when processing expenses or invoices. You can also attach several supporting documents to a single transaction or a single supporting document to multiple transactions for more flexibility.
So How DO I Get Started with TDM?
The basics of getting TDM enabled in your Vision database are as follows and take about an hour to setup:
- Enable FILESTREAM on the Vision SQL Server
- Create the Vision FILES database to store the uploaded documents
- Enable the FILESTREAM functionality for Vision
- Start using TDM inside Vision
Benefits of TDM
By enabling TDM you can:
- Reduce the work of keeping track of your supporting documents in the typical Folder/File structure on your network
- Streamline the process (especially for multi office firms) of allowing employees to scan and upload expense receipts directly to their Expense Reports in Vision instead of the typical procedure of scanning and emailing them to the main office or storing them in the Folder/File network
- A/P and Interactive Billing also allow the uploading of supporting documents to be attached to invoices, again saving the time and hassle of navigating the File/Folder network structure to find the associated documents
To go a step further when supporting documents have been attached to client invoices they can now be viewed by the appropriate project team members easily and also printed with the invoices as they go out to the client. TDM creates efficiency for accounting as well as staff by having the relevant project accounting documents easily accessible in a consistent location that is available to everyone that has access to the project.
Caveats of TDM Implementation?
There are a few things to remember if you implement TDM in Deltek Vision:
- Backup the FILES database at the same time as your Vision production database. So if you ever need to restore Vision to an earlier time you will also need to restore the FILES database from the same backup to maintain consistency between the two databases.
- The other consideration is the size of the FILES database. Although there is no limit to the size of the database, if it grows too large you may start to experience performance issues. As of now there is no known way to archive or reduce the size of the FILES database. This can be somewhat mitigated by making clear that the files uploaded to TDM need to meet a certain criteria (e.g. All documents uploaded to Vision must be in a PDF format and no more than 200 dpi greyscale scans). Unfortunately there is no way to set limits on the files at this time that can be uploaded to TDM. So clearly stating some criteria will help.
Subscribe Here!
Latest Posts
Posts By Category
- Professional Services (230)
- Technology Solutions (153)
- Deltek Vision (122)
- Building Business (110)
- Deltek Vantagepoint (101)
- Accounting (95)
- Project Management (90)
- CRM (68)
- Press Release (61)
- HR (53)
- ERP (52)
- Client Relationships (48)
- Marketing (48)
- Professional Services Firms (40)
- Deltek Clarity Report (27)
- Support (20)
- A&E Firms (19)
- Employees (18)
- Business Intelligence (17)
- Cloud (17)
- Video (17)
- Deltek Talent (16)
- Finance (16)
- Project Based Firms (16)
- Mobile (15)
- Communication (9)
- Deltek Insight (9)
- Data Visualization (8)
- Mergers and Acquisitions (8)
- Project Information Management (PIM) (8)
- Case Study (6)
- Executives (6)
- Driving Growth (4)
- business development (4)
- Human Capital Management (3)
- Resource Management (3)
- THOUGHT LEADERSHIP (3)
- human resources (3)
- Connect Add-In (2)
- Contract Management (2)
- Outsourced HR (2)
- Project Con (2)
- Proposal (2)
- Deltek + ComputerEase (1)
- Deltek Dela (1)
- Deltek ProjectCon (1)
- Information Technology (1)
- Outsourced Accounting (1)
- ProjectCon (1)
- SEO (1)
- password security (1)
Posts by Author
- Amanda McClain (3)
- Amanda Roussel (17)
- Amy Balassone (8)
- Aria Bounds (1)
- Bryce Crosby (1)
- Cate Phillips (9)
- Chris Simei (2)
- Dale Busbey (6)
- Erin Haver (1)
- Evan Creech-Pritchett (24)
- Full Sail Partners (104)
- Gina Stamper (2)
- Heath Harris (3)
- Jeff Robers (1)
- Jennifer Renfroe (64)
- Jennifer Wilson (2)
- Jenny Labranche (3)
- Joel Slater (8)
- Katie Sanner (1)
- Kelly Duquette (2)
- Kevin Hebblethwaite (8)
- Kim Stamps (2)
- Lee Frederiksen (1)
- Lindsay Diven (39)
- Lisa Ahearn (4)
- Matt McCauley (3)
- Michael Kessler, PMP (19)
- Nia Collins (1)
- Nicole Temple (3)
- Peter Nuffer (4)
- Rana Blair (19)
- Rhiannon Schaumburg (1)
- Rick Childs (8)
- Ryan Felkel (85)
- Ryan Suydam (10)
- Sarah Gonnella (66)
- Scott Gailhouse (21)
- Scott Seal (12)
- Sean Keller (1)
- Sparsha Muppidi (1)
- Tasia Grant, PHR (16)
- Terri Agnew, CPA (10)
- Theresa Depew (8)
- Timothy Burns (5)
- Tom Vandervort (1)
- Wendy Gustafson (17)
- Wes Renfroe (15)
- Wesley Witsken (1)