Striim Hub

Do you have a question? look no further

7 Conversations

S
sriram.pasamCommunity Manager
asked in Product Q&A

Syntax error in Continuous query(CQ) to inject NULL value for String field value

I am building a CQ to inject NULL values for String data fields that have “Not available” in the source database.CASE WHEN META(o,"TableName").toString()=="<schema-name>.<table-name>" then CASE WHEN TO_STRING(data[12]) ="Not Available" THEN putUserData(o, 'DENOMINATOR', "NULL") WHEN TO_STRING(data[13]) = "Not Available" THEN putUserData(o, 'SCORE', NULL) WHEN TO_STRING(data[14]) = "Not Available" THEN putUserData(o, 'LOWER_ESTIMATE', NULL) WHEN TO_STRING(data[15]) = "Not Available" THEN putUserData(o, 'HIGHER_ESTIMATE', NULL) ELSE OI am receiving the following compile error : Error Saving ComponentSyntax error at: CASENULL)Please fix the errors and click "Save" again. I also tried the following syntaxCASE WHEN TO_STRING(data[12]) ="Not Available" THEN NULLWHEN TO_STRING(data[13]) = "Not Available" THEN NULLWHEN TO_STRING(data[14]) = "Not Available" THEN NULLWHEN TO_STRING(data[15]) = "Not Available" THEN NULLReference docs : https://www.striim.com/docs/en/handling-null

1
S
28 days ago
igg-mario
igg-marioNew Participant
asked in Product Q&A

Forwarding Agent encryption in transit

While it’s great that you offer a Forwarding Agent for sources/destinations that have no direct public IP, I’m having a hard time finding any information as to whether or what sort of encryption in transit is used for the data conveyed by the Agent. And before I go digging into testing what it appears to do, I thought I’d ask here:  Does Striim Forwarding Agent use any encryption for any of its communication?Context here is that it was suggested to me that Striim might be useful in migrating from an antiquated MySQL ring replication cluster to a modern MySQL master-master cluster. Neither source nor destination cluster has, nor will have, a public IP address, and will not have any direct access available to to the greater internet.

3
igg-mario
4 months ago
J
johnInspiring
asked in Product Q&A

Streaming to kafka topic in confluent cloud

Are there any examples of using Striim’s KafkaWriter to stream data to a topic in Confluent Cloud? 

4
Robert Lauriston
11 months ago
J
johnInspiring
asked in Product Q&A

How do we flatten JSON in Striim?

I have a JSON Field in my PostgreSQL database with this format I want to take all the fields in this flat JSON structure and turn each of them into fields in a typed stream. How would I go about doing that? I tried using the ‘makeJSON’ function on the JSON string column but I’m unable to run JSONNode function on it.  Running the above query results in a ‘CRASH, cannot map’ exception.

1
S
1 year ago
D
Dabu720New Participant
asked in Community Q&A

Oracle CDC

We are using Striim to replicate data from Oracle to BigQueryI would like to know how can I find out for UIcurrent archived logs being mined by log miner The current DDL ( LCR , logical count record ) being processed)  Number of DDLs or LCR in the current Transaction or SCNThank You

2
D
1 year ago
Sweta Garai
Sweta GaraiCommunity Manager
asked in Community Q&A

Soft Deletes in Striim

How do I handle soft deletes in Striim? Does Striim performs an update process to mark some data as deleted instead of physically deleting it from a table in the database?

1
J
1 year ago
john.smith
john.smithCommunity Manager
asked in Community Q&A

Key Steps to launching a new CDC pipeline.

What are the key steps to launching a new CDC pipeline successfully? Wanted to get some ideas from the community on how to best approach that.

1
S
1 year ago

Badge winners

  • Striim Expert
    sriram.pasamhas earned the badge Striim Expert
  • Striim Expert
    igg-mariohas earned the badge Striim Expert
  • Friend of the Community
    Sweta Garaihas earned the badge Friend of the Community
  • Friend of the Community
    Sidhas earned the badge Friend of the Community
  • Streaming Sensei
    Sidhas earned the badge Streaming Sensei
Show all badges
Terms & ConditionsCookie settings