Solved

Using Filemaker to access Daceasy Data

Posted on 2009-04-06
5
715 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to recover a database from a user managed backup

920 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

15 Experts available now in Live!

Get 1:1 Help Now