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.

Sometimes life’s not fair. We’ve all been told this before, and if you are part of the human resources (HR) department, I’m sure you hear about fairness all the time. But what about you - the HR professional performing manual processes and navigating through a sea of paper work. Why do the accounting and operations departments have sophisticated software to make their lives easier? It’s just another one of life’s injustices, but it doesn’t have to be. That’s right, talent management systems are now being integrated into those awesome Enterprise Resource Planning (ERP) solutions your counterparts in other departments are using and are changing the way companies manage their human capital.
Today I felt compelled to speak to those that are struggling in the world. Whether it is your career, your home life or your past; we all have gone through hardship in our lives at some point and almost on a daily basis we have to overcome obstacles. What I’ve found is that everyone reacts differently during difficult times. Some better than others. Ultimately the choice you face is yours alone to make. That choice may be hard and something you don’t want to face it. Having the hard conversation or facing reality is nothing anyone wants to do. We must realize that ultimately the decision typically is made for you or by you.
Successful professional services business development professionals often view themselves as hunters. Much like the cavemen or nomads, this group of professionals is responsible for learning how to navigate the dangers of the world to bring food back to the pack. This overly simplified analogy challenges us to view business development tools and efforts on a visceral level.
Deltek Vision CRM is uniquely designed for scalability within your organization. Whether you are a novice user, or a tenured pro, Deltek Vision CRM is designed to allow you quick and easy access to the relationship data that will separate your firm from the rest of the pack! However, regardless of the capabilities of the software, the success of your firm’s rollout is affected heavily by your past experiences with services management platforms, the firm’s overall culture and philosophies of client management, and your users’ level of buy-in. Maximizing the value that the system brings to your firm requires careful planning and strong commitments to the implementation.
I don’t know of a single Professional Service firm without a formal contract management process. Firms spend significant dollars purchasing contract templates and some even retain legal counsel for review. Everyone knows that the contract is an important document in any project undertaking.
Marketing is tough. Marketers are expected to be jacks of all trades: Brand manager, technology expert,social butterfly and head collaborator. Yet at the end of the day marketing is often a thankless job. However, the fruits of our labors are often six degrees of separation removed from our actual efforts. We do not directly sell and there is no physical doo-dad at the end of the day that we can point to in order to justify our existence. Enter the world of ‘marketing analytics.’
Have you ever thought about all the information a firm collects on a daily basis? Think about it, every department is collecting information all the time. More importantly,
Full Sail Partners, a Client Feedback Tool and Deltek Premier Partner, has been recognized by Deltek as a member of the Million Dollar Club. Additionally, Deltek has selected Full Sail Partners as a 2015 Premier Partner. Deltek Premier Partners provide sales, implementation, consulting, support and customization services for project-oriented Professional Services organizations and are required to meet and maintain a number of standards with respect to sales and marketing goals.