I've only been using Jaspersoft for a few days.

I'd like to call another Job using tRunJob.

I am passing in a List of Table Names and am using tContextLoad to create a varibale called TableName.

I have an extraxct job defined for each table and wish to call that Job when it appears in the List of names being passed in.

Unfortunately the "Job" attribute of tRunJob does not allow Manual entry.

Is there any easy way to override this and set the name of the Job to be called dynamically by evaluating TableName ?

If I could get "Job" to evaluate "(String)((String)context.getProperty("TableName"))" then that would be great.

i know this might be a very 'noob' question for you guys, but i've been searching for hours now and i couldn't really find anything.

for exploration purposes i've made a OLTP db for POS transactions, and i've also made an OLAP db (in star schema) to transfer the data from the OLTP.

do you guys know of any resources that can teach me how transfer data from my OLTP db to OLAP db? i realize that the format will have to be changed.

any help is much appreciated. thanks!

I have to extract 28 tables from MS SQL Server 2000 using jaspersoft etl, transfrom them and load them onto a Mysql database. The question is:

Does this mean creating 28 jobs? This I know how to do.

Or can I extract them in one job? If so how?

Post Edited by rumbi at 02/07/2012 17:32

Post Edited by rumbi at 02/07/2012 17:35

I have to extract 28 tables from MS SQL Server 2000 using jaspersoft etl, transfrom them and load them onto a Mysql database. The question is:

Does this mean creating 28 jobs? This I know how to do.

Or can I extract them in one job? If so how?

"Jaspersoft ETL Pro" Version: 4.1.2 Build id: r53616-20110106-0658 on

X86 laptop running Microsoft Windows XP Professional Ver 5.1.2600 SP3 Build 2600

I am using Jaspersoft ETL for the first time.

I created a new project and am trying to create a database connection in Metadata to connect to a remote SQL Server 2008 DB.

I choose/enter:

Name: devSTAGE

Status: Development

DB Type: Microsoft SQL Server

Login:  xyz

Password: abc

Server: [IP address of the server running the MS SQL 2008 database]

Port: 1433

Database: STAGE

CHECK command button is not enabled and clicking on FINISH also does not take me anywhere.

How can I fix this?

Announcing JasperReports Server Community Edition v4.5

JasperReports Server 4.5.0 now includes the following:

• Evaluation Central - Jaspersoft is pleased to provide this resource as a gateway to new users exploring the Jaspersoft BI Suite. Point your browser to http://www.jaspersoft.com/getting-started for tools, documentation, and support to evaluate our solutions. This one-stop shop helps you complete your evaluation and engage with the Jaspersoft team when you need us. Note that this location covers both Community and Commercial features. 

• Improved Report Viewer:
  
  • Interactivity - Reports created with JRXML table components are now interactive directly in the server's Report Viewer.  Users can sort the table by clicking one or more column names and filter displayed rows by right-clicking the column name, selecting an operator, and entering a value.
  • Excel output format - New export options in the Report Viewer produce true single-page spreadsheet output in Excel and XLSX format. These options run the report again to seamlessly fill tables and crosstabs, so that the spread-sheet is ready for further data manipulation in Excel. The previous Excel and XLSX options are still available with the Paginated label. The paginated options do not run the report again (faster), but may contain page artifacts such as column or row breaks.
  • Interface - The Report Viewer has been improved to show the report name at the top and move pagination controls above the report contents.

• Web Services REST API - In this release, new REST (Representational State Transfer) web services provide complete access to repository resources and server administration. Remote applications can now manage users and roles through RESTful methods. In addition, the REST methods are enhanced to interact with scheduled jobs.

• Security - JasperReports Server now has enterprise-grade security through the integration of a comprehensive security framework. This new security framework protects the server against common security threats. Customers can configure the security settings (switch on/off or change the security rules) based on their perceived threat level.

• Database Server Support - JasperReports Server now supports MySQL 5.5 as an RDBMS host for the repository database. You must provide the required JDBC driver for this platform. Refer to the Installation Guide for details.

• Code compilation support for Java 1.6. With this release, JasperReports Server no longer supports Java 1.5. This means that all Java 1.6 code syntax is now fully supported.

• Fix to issue found in 4.2.1 where the View > Repository context menu was missing the Add Resource > File option. The menu option has been restored. 

I would like to know if it's possible with JasperETL analize an XSD schema?

Thanks,
A.

Could someone pls tell me if there is some component in JasperETL that could run a local/remote script of any kind (or, if not, what kind of scripts)? More exactly, I want this component to read connection details of many (say, more then 100 000) FTP servers from a script/file, connect to those servers and get data of specified format into an input file in my job...

Thank you in advance,

Marius