Solved

ODBC connection to Yardi 3.2 how to

Posted on 2008-06-26
6
1,924 Views
Last Modified: 2013-12-25
I just started working with an old version of Yardi 3.2 and I would like to be able to connect to the database using an ODBC connection.  Unfortunately their version is so old, I can't find any help on the subject so hopefully, I can find a Yardi expert that can help (if you can remember that far back).

What I did find is that it is running on the Microkernel Database Engine version 6.15 using something called btrieve.  There is an ODBC driver that I downloaded (DataDirect Connect) that connects fine to the microkernel database engine, but it doesn't see any of the tables that exist in Yardi.  It says that "connection established!" but there are no tables that it finds.

 I don't know what to do here...  Can anyone offer suggestions?
thanks,
mike
0
Comment
Question by:mikegiusti
  • 3
  • 2
6 Comments
 
LVL 18

Accepted Solution

by:
mirtheil earned 125 total points
ID: 21876556
ODBC access to Btrieve data requires DDF files (FILE.DDF, FIELD.DDF, INDEX.DDF, possibly others). The DDFs describe the record structure for the tables.  If Yardi doesn't provide these DDFs, you'll need to create them.  You'll need to know the exact record structure of each table in order to create them.  There are tools that can help guess the structure but most of them aren't available for Btrieve v6.15.
Btrieve itself does not store field information so DDFs are required by anything other than the original program.  
0
 

Author Comment

by:mikegiusti
ID: 21877283
Thank you for pointing me in the right direction.

So without help from yardi, is this a dead end?  Unfortunately, I am looking at this for a friend that doesn't want to spend any money on the application, and I dont  think that we can contact yardi for support as it will incur a cost.  Reading about creating DDF files seems challenging to the most experience people, and I am a novice.

Thanks again,
mike
0
 
LVL 28

Assisted Solution

by:Bill Bach
Bill Bach earned 125 total points
ID: 21877541
Mirtheil is correct -- you must have DDF's.  DDF's are created by the application developer (or by someone who deeply understands the data structures) and provide the ODBC access.  If Yardi has them, they would be the ones to get them from.

My company has created partial DDF definitions for ONE version of Yardi, but we did this on a newer version which would not be compatible with your own files.  Additionally, this is far from a complete set of files (I think there are 6 tables currently defined), and you'd still need the ODBC driver and additional information on linking the files to extract data effectively.

If this is a one-time data extract to migrate to another application, I would recommend just using the Yardi reporting tools to dump the data out directly.  If you are trying to build an extension to Yardi via ODBC, then it would be possible, but a substantial amount of work would be required -- FAR beyond the free & easy solution you are looking for.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Closing Comment

by:mikegiusti
ID: 31471051
Thank you for the confirmation.  I will see if we can get in touch with Yardi as I would like to build a reusable interface to the database.  Probably wont be free or cheap, but I dont see them upgrading to a newer version in the immediate future.
thanks,
mike
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 21877875
If you do create something that has real value to the Yardi community in general, please let us know!  Selling the solution to other users could also help defray development costs.
0
 

Author Comment

by:mikegiusti
ID: 21877909
sounds good, although, I am a little discouraged now.  Hopefully, Yardi can come back with a solution that I can impliment.
thanks,
mike
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now