Thank you I've got that bit the question is do we need to purchase a Oracle Licence from oracle to read/write data from filemaker to the Oracle tables via the ODBC driver.
I've already built the interface just want to make sure we are compliant with Oracle read/writing to there tables.
Does that require a oracle licence and if so what type of Oracle licence, what's the cost and how to purchase it.
Current have Filemaker Server running a script every 10 minutes read/writing form filemaker tables to Oracle tables via ODBC.
You do not need a extra license from Oracle to be able to use ESS to reach tables in Oracle database.
I would not use FMS to pull data to FileMaker. Much better if you use ESS and use tables from Oracle natively in FileMaker
You can also just use the FREE Oracle JDBC driver and also the FREE FMP JDBC driver and you can easily write FREE Java code to work with both environments.
EASY TO DO.
Clive Smith wrote:
Does anyone know what Oracle licence would be needed to interface with Oracle 11g database via ODBC.
It will only be the FileMaker Server interacting with the Oracle tables
Nothing else uses Oracle? Then why have it? Why not use a free database?
The Account system uses Oracle
Hi Johan, was using the oracle tables natively at 1st by was really slow and the data doesn't need to be live so just mirror the tables and the script jut checks for changes between Oracle and FM tables seems to work a lot fast. Was getting a long lag when FM was access a oracle table.
If I can get my head around it maybe JDBC may work better.
Was just worried I maybe breaking Oracle licensing accessing the data.
If you have JDBC questions, I could definitely help. Just post back.