Hi. Im quite new to Libre and would like to learn more particularly about Base. I want to export few tables from one system and create them in Base. For this Im using Talend Open Studio for Data Integration and from what I see it says something about Embedded HSQLDB- dont know what this embedded means but Im trying to use tHSQLDbOutput component to write entries in the .odb file I created locally.
However there is some extra information Talend requires me to fill before the import, such as ‘Running Mode’ (HSQLDb Server, HSQLDb WebServer, HSQLDb In Process Persistent, HSQLDb In Memory) and based on this adds few more, such as Host, Port, Username etc.
What should I use and fill if I simply want to write entries into locally stored .odb file? Many thanks for help
Are you currently connected to a database such as MySQL?
No, should I be? I assumed this Base is Access kind of tool… something like MS Access alternative, standalone database. So you say Base is just client to connect db?
Neither Base nor Access are actually databases. They do, however, come packaged with a database which they interact with. This is about Base.
First, Base, in its’ default mode, uses HSQLDB v1.8. This is an older version of the database and it to be replaced someday by Firebird. An .odb file (Base) is really a zipped file of the components necessary to run your designed front end to a database and in the case of Embedded (Base default) the data files are also included. Embedded is a potential problem for data loss during the zip/unzip internally each time a project is opened or closed. Since HSQL resides within LibreOffice, embedded DB’s are not easily accessible to outside sources.
I brought up MySQL (others apply as well) because external databases are fairly easy to connect to through Base and provide the separation of data. If you had been using something like this the process would be much simpler.
To accomplish what you want actually has nothing to do with Base. Rather it is getting the data from Talend and into a “Database” usable by Base. Now knowing almost nothing about Talend, I briefly noticed a mention of possible connection to DB’s such as MySQL and PostgreSQL (which is the reason for the question).
Another way to get data into a table in Base is through a CSV file.
But going back to your original way, you cannot go directly to an embedded DB. Minimally you need to create a split DB. HSQLDB then needs to run in server mode and the Base .odb would access the data through the server. You would then access HSQLDB from Talend with the server properties and move your data. All this is not a small task if you have no background in this type of setup.
As you mentioned being fairly new to LO, here is the location for documentation: click here. This link points to all the LO products and not just Base. Hope this didn’t add confusion.