Bekwam Data as a Service

Fixing a SQL Server Connection Failure in a Dev Environment

sales@bekwam.com — Wed, 07 Mar 2012 08:14:22 PST

I spent more minutes than I would have liked en/disabling TCP/IP and turning on and off my firewall to fix this connection problem in SQL Server

Read more »

[AUDIO] Integration Tools Podcast, Episode 55: Talend. Pentaho. DataStax. Information Builders.

sales@bekwam.com — Sun, 04 Mar 2012 04:54:31 PST

Spend a few minutes a week to keep on top of the data integration tools market. Episode 55 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. This week covers Talend, Pentaho, DataStax, and Information Builders.

Integration Tools Podcast Episode 55

For more podcasts, visit http://www.bekwam.com

Presenting an Operations Schedule with Talend and Jaspersoft: Part 2

sales@bekwam.com — Sun, 26 Feb 2012 15:39:03 PST

[The second in a two part series on loading operations schedule data using Talend Open Studio and writing a report using Jaspersoft's iReport Designer]

I've worked on and heard of a few cases where the data model used to store hours of operations isn't ideal for presentation. This post contains instructions for creating a Jasper Report using iReport Designer to produce a condensed schedule based on such a data model.

Read more »

[AUDIO] Integration Tools Podcast, Episode 54: Pervasive.

sales@bekwam.com — Sun, 26 Feb 2012 04:49:31 PST

Spend a few minutes a week to keep on top of the data integration tools market. Episode 54 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. This week covers Pervasive.

Integration Tools Podcast Episode 54

For more podcasts, visit http://www.bekwam.com

Presenting an Operations Schedule with Talend and Jaspersoft: Part 1

sales@bekwam.com — Sat, 25 Feb 2012 13:07:33 PST

[The first in a two part series on loading operations schedule data using Talend Open Studio and writing a report using Jaspersoft's iReport Designer]

A reader recently asked about manipulating schedule data for more efficient presentation. I've worked with schedulesas part of the Open Travel Alliance which is an XML standard for sharing travel industry information. In both cases, the data structures involved in the intake of the data weren't suited for the display. Talend Open Studio and Jaspersoft can resolve the discrepancy.

Read more »

Parameterizing a JasperReports Crosstab

sales@bekwam.com — Mon, 20 Feb 2012 04:16:29 PST

To parameterize a JasperReports crosstab, create a parameter in the main report and link it with a crosstab parameter.

Read more »

[AUDIO] Integration Tools Podcast, Episode 53: Penatho, Talend, DataFlux, Pervasive, expressor, Informatica.

sales@bekwam.com — Sat, 18 Feb 2012 13:22:39 PST

Spend a few minutes a week to keep on top of the data integration tools market. Episode 53 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. This week covers Pentaho, Talend, DataFlux, Pervasive, expressor, Informatica.

Integration Tools Podcast Episode 53

For more podcasts, visit http://www.bekwam.com

Testing a Static Method with EasyMock

sales@bekwam.com — Tue, 21 Feb 2012 05:41:39 PST

EasyMock is a test mocking library for Java. EasyMock lets you create test objects for your unit tests that mimic the behavior of the system under test. These test objects allow you to write a unit test that is focused on a single class and not on the supporting objects.

One deficiency with EasyMock is that it can't handle static methods. In my consulting jobs, I see this a lot of this type of code, particularly from programmers not coming from an object-oriented background and also in popular commons libraries like Commons Lang.

boolean matchesFlag = Utils.isMatch(s1, s2);

where isMatch() is a static method and Utils is a collection of static methods used throughout the application.

Read more »

Calling a Stored Procedure from Talend Open Studio

sales@bekwam.com — Sun, 05 Feb 2012 14:44:42 PST

Writing to a set of related tables may present a timing challenge to Talend Open Studio developers. This post shows how to use a stored procedure to write to two related MS SQL Server tables.

Read more »

[AUDIO] Integration Tools Podcast, Episode 52: Talend. expressor. Pentaho.

sales@bekwam.com — Sat, 21 Jan 2012 12:06:15 PST

Spend a few minutes a week to keep on top of the data integration tools market. Episode 52 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. This week covers Talend, expressor, and Pentaho.

Integration Tools Podcast Episode 52

For more podcasts, visit http://www.bekwam.com.

[AUDIO] Integration Tools Podcast, Episode 51: CloverETL. Adeptia. Jaspersoft.

sales@bekwam.com — Sat, 14 Jan 2012 17:29:09 PST

Spend a few minutes a week to keep on top of the data integration tools market. Episode 51 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. This week covers CloverETL, Adeptia, and Jaspersoft.

Integration Tools Podcast Episode 51

For more podcasts, visit http://www.bekwam.com.

Adding a Measure to a Jasper Reports Crosstab

sales@bekwam.com — Sat, 14 Jan 2012 05:11:52 PST

This is a tutorial showing how to add a measure to a crosstab in a Jasper Report. When using the crosstab wizard, add new measures to existing cells.

What Causes a ConcurrentModificationException?

sales@bekwam.com — Thu, 05 Jan 2012 03:40:51 PST

In Java, a ConcurrentModificationException can occur when attempting to modify a Collections object (ex, java.util.List) outside of an Iterator. The documentation points to threads as a possible cause, but you can get this exception even doing single-threaded programming.

Read more »

[AUDIO] Integration Tools Podcast, Episode 50: 2012 Integration Tools Predictions

sales@bekwam.com — Sun, 01 Jan 2012 18:50:36 PST

Spend a few minutes a week to keep on top of the data integration tools market. Episode 50 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events.

Integration Tools Podcast Episode 50

For more podcasts, visit http://www.bekwam.com.

Top Ten Timesaving Talend Tips of Two Thousand Eleven: Part 2

sales@bekwam.com — Sun, 01 Jan 2012 14:50:30 PST

The second part of my 10 Talend Open Studio for Data Integration time-saving recommendations from 2011.

Read more »

Top Ten Timesaving Talend Tips of Two Thousand Eleven: Part 1

sales@bekwam.com — Sun, 01 Jan 2012 14:49:30 PST

The end of the year is the season for lists and I just listened to the S's in the complete Beatle's catalog on the radio. Here are 10 timesaving tips for Talend Open Studio for Data Integration that I used in 2011.

Read more »

tMSSqlLastInsertId Returns 0

sales@bekwam.com — Wed, 28 Dec 2011 05:36:27 PST

If you've built a Talend Open Studio job that inserts records into a multiple MS SQL Server tables, you can use the tMSSqlLastInsertId to retrieve the value of an auto-incremented IDENTITY column set in a prior insert.

Read more »

NamespaceHandler Error Using Spring Batch

sales@bekwam.com — Wed, 21 Dec 2011 15:19:59 PST

After running Spring Batch programs in an IDE (Eclipse, IBM RAD), you may notice a NamespaceHandler error when you attempt to run the programs from an exported Runnable JAR.

This error is caused by the archiving process which overwrites the /META-INF/spring.handlers file found in a number of the Spring JARs. Through the IDE, these handlers are additive; each JAR's META-INF resources are added to the classpath. However, the Runnable JAR process will put only a single spring.handlers file on the classpath which is the last one in the Order / Export window in the IDE.

The solution is to prepare a comprehensive spring.handlers file and update the JAR after all of the archiving is completed. This can be done manually, with a script or Ant task, or by packaging your own JAR containing only your finalized /META-INF resources. If you go the JAR route, make sure this JAR is last in the Order and Export window.

Creating a SQL Server Identity Column with Talend Open Studio

sales@bekwam.com — Sun, 18 Dec 2011 12:51:41 PST

Talend Open Studio for Data Integration will execute table-creating DDL as part of a data transformation. When using Microsoft SQL Server as a target, use the "Specify identity field" to define the column with IDENTITY(1,1).

Read more »

[AUDIO] Integration Tools Podcast, Episode 49: Informatica, expressor, Melissa Data.

sales@bekwam.com — Sat, 17 Dec 2011 19:49:49 PST

Spend a few minutes a week to keep on top of the data integration tools market. Episode 49 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 49 covers Informatica, expressor, Melissa Data.

Integration Tools Podcast Episode 49

For more podcasts, visit http://www.bekwam.com.

Exporting Oracle XML to a File with Talend Open Studio

sales@bekwam.com — Tue, 13 Dec 2011 04:51:58 PST

Oracle stores XML in a database column using a proprietary data type called XMLType. XMLType is a CLOB that can be exported to a file as a block of text using Talend Open Studio.

Read more »

[AUDIO] Integration Tools Podcast, Episode 48: Integration Tools Incursion into App Infrastructure

sales@bekwam.com — Sat, 10 Dec 2011 07:09:30 PST

Integration tool vendors with an MDM product offer to replace custom coding of a CRUD application with an off-the-shelf solution, just as these vendors replace custom data-loading code with a tool.

Spend a few minutes a week to keep on top of the data integration tools market. Episode 48 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 48 covers SnapLogic, Talend, expressor, Melissa Data, Pentaho, Extol.

Integration Tools Podcast Episode 48

For more podcasts, visit http://www.bekwam.com.

[VIDEO] Coded to Last with Talend Open Studio

sales@bekwam.com — Fri, 09 Dec 2011 08:42:10 PST

Create a Talend Open Studio for Data Integration job configured by a flexible properties file and supporting environment-specific actions for easy development.

[AUDIO] Integration Tools Podcast, Episode 47: Talend. CloverETL. DataFlux.

sales@bekwam.com — Sun, 04 Dec 2011 17:52:03 PST

Spend a few minutes a week to keep on top of the data integration tools market. Episode 47 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 47 covers Talend, DataFlux, and CloverETL.

Integration Tools Podcast Episode 47

For more podcasts, visit http://www.bekwam.com.

64-bit Microsoft Access with Talend Open Studio Data Integrator

sales@bekwam.com — Sun, 04 Dec 2011 13:49:29 PST

If you have trouble connecting to Microsoft Access with Talend Open Studio Data Integrator on a 64-bit machine, the problem may be that 64-bit ODBC drivers are missing.

Read more »