Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Connecting with a PROGRESS database
- Thread starter Nro
- Start date
Nro,
I'm aware of "Progress" by name only, I've never had any personal experience with a Progress database.
That being said, if it is ODBC compliant, FM will likely be able to pull data in. The downside is that you really do need to import that data. I share your desire to query another brand DB without the need for importing but unfortuneately, it is not possible. I'm about 98% sure I'm correct with this statement. Jean, do you agree?
-Striker
I'm aware of "Progress" by name only, I've never had any personal experience with a Progress database.
That being said, if it is ODBC compliant, FM will likely be able to pull data in. The downside is that you really do need to import that data. I share your desire to query another brand DB without the need for importing but unfortuneately, it is not possible. I'm about 98% sure I'm correct with this statement. Jean, do you agree?
-Striker
>> I'm about 98% sure I'm correct with this statement. Jean, do you agree? (Striker)
Yes.
With ODBC or JDBC you can make databases 'talk' to each other. Kind of same language that both will understand.
The key words in this are 'access data' and 'exchange' data.
For example, you can create charts, analyze numbers, and generate reports using FileMaker Pro data in other applications.
Or interacting with data sources on the same computer or over a network (Windows and Mac OS). For example, you can import data from a Microsoft Access or Oracle database, or even Progress (don't know if Progress suports ODBC, would be suprise if not...) into FileMaker.
With the new feature in FM 7/8 and with a program like AutoIt you can do things 'outside' the box, but (as FM developer) I prefer to import data, do what I have to do, inside FM, and send data back to the source, rather than build/do something in an external program.
Yes.
With ODBC or JDBC you can make databases 'talk' to each other. Kind of same language that both will understand.
The key words in this are 'access data' and 'exchange' data.
For example, you can create charts, analyze numbers, and generate reports using FileMaker Pro data in other applications.
Or interacting with data sources on the same computer or over a network (Windows and Mac OS). For example, you can import data from a Microsoft Access or Oracle database, or even Progress (don't know if Progress suports ODBC, would be suprise if not...) into FileMaker.
With the new feature in FM 7/8 and with a program like AutoIt you can do things 'outside' the box, but (as FM developer) I prefer to import data, do what I have to do, inside FM, and send data back to the source, rather than build/do something in an external program.
- Thread starter
- #5
I now understand.
In fact, Filemaker can act as a data repository by importing data from any source. But I can't write script in FM to update data directly TO an other databases.
And yes, there is ODBC drivers for PROGRESS (in fact, the software is Power GUI, made from Quasimodo)
Thanks again for your light.
Nro
In fact, Filemaker can act as a data repository by importing data from any source. But I can't write script in FM to update data directly TO an other databases.
And yes, there is ODBC drivers for PROGRESS (in fact, the software is Power GUI, made from Quasimodo)
Thanks again for your light.
Nro
- Status
Similar threads
- Locked
- Question