Do you have a question? look no further
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) ="Not Available" THEN putUserData(o, 'DENOMINATOR', "NULL") WHEN TO_STRING(data) = "Not Available" THEN putUserData(o, 'SCORE', NULL) WHEN TO_STRING(data) = "Not Available" THEN putUserData(o, 'LOWER_ESTIMATE', NULL) WHEN TO_STRING(data) = "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) ="Not Available" THEN NULLWHEN TO_STRING(data) = "Not Available" THEN NULLWHEN TO_STRING(data) = "Not Available" THEN NULLWHEN TO_STRING(data) = "Not Available" THEN NULLReference docs : https://www.striim.com/docs/en/handling-null
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.
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.
Already have an account? Login
Login with SSO
Login to the community
No account yet? Create an account
Login with SSO
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.