Ask Your Question

Write entries in Base using Talend

asked 2017-02-02 16:57:53 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

edit retag flag offensive close merge delete


Are you currently connected to a database such as MySQL?

Ratslinger gravatar imageRatslinger ( 2017-02-02 18:32:19 +0100 )edit

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?

Razza gravatar imageRazza ( 2017-02-02 23:54:38 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-02-03 00:35:33 +0100

Ratslinger gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-02 16:57:53 +0100

Seen: 182 times

Last updated: Feb 03 '17