?
Solved

ODBC connection to Yardi 3.2 how to

Posted on 2008-06-26
6
Medium Priority
?
1,985 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 18

Accepted Solution

by:
mirtheil earned 500 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 500 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
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

765 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