Solved

ODBC connection to Yardi 3.2 how to

Posted on 2008-06-26
6
1,963 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 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 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