With the landscape of Real Estate companies growing and turning to Yardi’s expansive Application Stack and infrastructure to manage their business there is a growing need to get your data out of Yardi and into the hands of an analyst or power user via extracts or a data warehouse for analytical purposes.
Getting data back from any software as a service platform can be tricky especially due to proprietary rules. Unfortunately, out of the box reporting is never robust enough to meet your specific needs and the data you need is stuck behind their servers. Fortunately, there are two efficient ways to get your data from Yardi based on if you are using their service as their primary software as a service or if you choose their hosted private cloud option. To see which one is right for you, please reference this post.
How to get your data from Yardi
There are two primary options you can use. First, Yardi provides a mechanism to download your database backups from an SFTP they will configure for you. You can script a job using Python or Command line to do this for you and restore the SQL database locally. Second, if you hit a high enough property threshold and pay extra, they can grant you direct VPN access to your data.
Download the free whitepaper below to see get more details on how to download and access your data from Yardi Voyager. This white paper will show you the step by step process on how to set up the Yardi data refresh process.
Get the Free CRE Data Whitepaper on Getting Data from Yardi Here
If the contents of this post are outside of your wheelhouse, don’t worry, this is why we started CREXchange.io. We even have free out-of-the-box Power BI Reports to help you get off the ground with Yardi Data Integration and help run your CRE business. Contact us there for more details or a demo!
Update!
There is a new method available which allows you to accomplish this same task more efficiently as well as more frequently. Please see the respective post on Getting Data from Yardi via Logshipping!
Get your data via SQL Logshipping!