Latest Topics

Transfer Mysql database

2010-08-19

Hello,

I am in the process of transferring data and contacts onto a Mysql database.

I have had some help and am trying to get a software solution.

So main features would be to migrate large amounts of data and contacts every day. The migration would be done manually.

Thanks for the help.

JasperETL-All-r35442-V3.2.3 install on Mac 10.6 (

2010-08-12

I've downloaded the package and unzipped. When I try to run it I get a "You can't open the application because it may be damaged or incomplete. I'm not running rosetta. Will this build run without rosetta, or is it required.

How can I get a build that will run?

JasperETL : Connection Issues to Oracle (10/11)

2010-08-09

I cannot seem to make a connection to Oracle 10 or 11.

Example (Using Oracle SID connection)

a. Create a new connection.

b. Enter necessary elements like SID, port, userid/password etc.

c. Click 'Check' (as indicated on top of the dialog box).

Nothing happens here. Wait and wait but nothing happens.

I noticed after a while the cursor goes to the 'Null' field on the dialog box.

Click finish. Nothing happens.

Please advice.

Thanks.

Dynamic destinations in tMap (schema and number)

2010-08-09

Hello,

I am currently working on a project designed to be a generic ETL process for CSV files. I already used JasperETL to load data from such a file, but i noticed i need to specify a schema for input files. Also on the tMap component i need to specify destinations and their schemas.

Is there some way to do this dynamically? The ideea of the application is to use a configuration file that will tell everything: destinations, each field in the CSV along with it's type and some validation to be applied, and it's destination. The problem is this is designed to be extremely generic, so i don't know the schema for the input file or for the destinations (or even the number of destinations) before run-time.

Is there some way this can be implemented using JasperETL?

How to change a composite key?

2010-08-09

Hi,

I have three tables: A, B and AB and the key of table AB is a composite key of table A and table B.
How can I change an composite key between two tables?

I tried with tMap, but I need to link the key that I want to change, then I can't indicate what key will be the new value...

Thanks a lot

How to create custom components?

2010-07-28

Dear All.

I need to create a new custom component for my product so other jasperETL users can use to import and export data from my system (same as the sugar CRM componant for example), i searched the internet for a refrance helping creating custom component and i didnt find anything useful can anyone help me find any resource to get me start building such a component ?

thanks and best regards,

Razi AL-Qasem

Post Edited by razi.alqasem@gmail.com at 07/28/2010 12:02

Post Edited by razi.alqasem@gmail.com at 07/28/2010 12:03

Post Edited by razi.alqasem@gmail.com at 07/29/2010 07:48

Source code for JasperETL

2010-07-18

I've just tried to checkout source code for JasperETL and found the specified directory is empty.

http://jasperforge.org/svn/repos/jasperetl/

Is JasperETL an open source project or is it actually an closed source project?

Information about JasperETL

2010-07-13

Hello,

I want to know which interfaces JasperETL (Open Source) supported... BAPI, ODBC, OLE DB, OLE DB FOR OLAP?

And which Datasource is supported? MS Office, Flat Files, Data form internet??

I have foud a document:

JasperETL 3.2.1 Components Reference Guide

The wrote components there are for the Open Source Edition or for the professional? Where can i get information about the components for the Open Source edtion?

i am happy about every information :)

Thank you

Post Edited by lauramoser at 07/13/2010 13:56

Export Data in JasperServer

2010-07-13

Hello,

I have not many experience in this topic, so sorry my question...

I want to export an csv file in my JasperServer. Or have i to import the file from ETL in JasperServer?

Please help me!

Thank you

JasperETL 3.2.3 does not start on Ubuntu 10.04

2010-07-12

I copied the content of the tarball.

Obviously it is not intented to work in a place like /usr/local/...

So I unpacked in my home. From there I get the login panel, I enter some e-mail in the local connection,

I cannot copy the demo project, so I try to make a new one. Which I could define, but when I say open after defining, I get a dialogbox with a title "JasperETL-linux-gtk-x86" and no content that lasts for ever ...

=> same tarball works on windows, but this doesn't help for me.

Anybody experienced the same issue ?

Log file attached.

Post Edited by pkienner at 07/12/2010 11:02

Post Edited by pkienner at 07/12/2010 11:06