Solved

Using Filemaker to access Daceasy Data

Posted on 2009-04-06
5
716 Views
Last Modified: 2013-12-07
Hey there.

We use Daceasy Accounting 16 in our office and i would like to use our data in filemaker so i could combine other data sources to create some useful reports.

I have heard that since Daceasy uses pervasive SQL, that it may be possible to make a live connect with a database software like filemaker.

Is this possible? if so, how would i go about connecting it?
0
Comment
Question by:nanio
5 Comments
 
LVL 9

Accepted Solution

by:
jvaldes earned 250 total points
ID: 24075304
If pervasive SQL has ODBC drivers for your platform then that is the easiest way. Use the import command with ODBC it should read the available tables, choose the table and the fields you want and you are on your way.

You may want to delete the tables every time and renew them or just update them. You should relate the import to the data you are going to create locally rather than adding your fields to the import table, this will allow you to reconstruct the import without damaging your local data
0
 

Author Comment

by:nanio
ID: 24075728
I apologize for my lack of expertise but how would i be able to check if pervasive SQL used in Daceasy had ODBC drivers?
0
 
LVL 28

Assisted Solution

by:Bill Bach
Bill Bach earned 250 total points
ID: 24077513
The ODBC drivers are part of the solution, but you also need DDF's.  Check here for more information:
    http://www.goldstarsoftware.com/press.asp
Get the white paper on Accessing Btrieve Files from ODBC.  There's another paper on checking your database engine version, too, which will come in handy if you continue down this road.

The built-in tools that come with PSQL do not have native ODBC support for other database types.  However, you CAN use just about any other ODBC-based tool to move the data, including simple things like MSAccess.  A better solution is to migrate the data using an Extract/Transform/Load (ETL) tool, so that you can clean up any issues whien you move it around.  See Pervasive's own Data Integrator as an initial solution, or open source solutions from Jaspersoft and Pentaho.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

776 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