Solved

Record Header Attributes for Oracle Bulkload

  • 18 September 2023
  • 3 replies
  • 49 views

Userlevel 4
Badge

I am trying to use Oracle Bulkload Origin to read multiple tables from Oracle database. I want to use the tablenames from source to write to destination as files names. 

In the preview I can see some attributes but when I try to capture them in Expression Evaluator they appear null. 

 

Here is my config for expression evaluator

 

Is it something to do with oracle version? or data collector version?

I am using 

Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

SDC version 5.5.0

 

I can see the jdbc.tables if i use JDBC Multitable Consumer but I want to use Bulkload.

icon

Best answer by Bikram 18 September 2023, 20:52

View original

3 replies

Userlevel 4
Badge

I tried it with Oracle 19c 19.3.0.0 and still the same behaviour

Userlevel 5
Badge +1

@saleempothiwala 

can you please give a try with below expression 

 

 

Userlevel 4
Badge

@Bikram 

 

 

Yes, I can extract the table name from this now :-) Thanks for the work around!

Reply