Skip to main content

Solved

11 Conversations
Emrah
EmrahParticipating Frequently
asked in Community Q&A
CDC problem with 21C

Dear All,i am trying to create 2 pipelines from Oracle to Postgres.the first one is initial Oracle to Postgres, it worked very well, and schema conversion tool migrated 2 example tables to postgres. but i have an issue with Oracle CDC.i have logminer user on oracle which is striim and i have table owner which is scale_user and i have 2 tables scale_data and scale_data2.i am not using container and PDB on 21C, striim and scale_user are common user.i am receieving an error like below when i insert a data to the tables after commit.i see that reader is looking for tables like CDB$ROOT.TEST.SCALE_DATA but i am not using container so how can resolve the issue.There was no problem with initial load, the problem is related with CD process. Thanks in advance. [{ "_id" : null, "timeStamp" : 1707166962232, "originTimeStamp" : 1707166964000, "key" : null, "sourceUUID" : { "uuidstring" : "01eec465-3101-b301-b854-42010a9c000a" }, "data" : [ "862412", "1", "1", "460" ], "metadata" : { "RbaSqn" : "50

2138
Emrah
mahesh_gupta
mahesh_guptaNew Participant
asked in Product Q&A
Is Postgresql to Oracle CDC pipeline possible ?

Hi Team, Can we create a Postgresql to Oracle CDC pipeline to make sure oracle is sync with postgresql post migration.  Regards, Mahesh

831
john
Sweta Garai
Sweta GaraiCommunity Manager
asked in Product Q&A
Error saving CQ with Modify

I am trying to write a CQ with MODIFY statement that replaces all “Not Available” to NULL but I am getting an error “Left expression do not refer to an object”. Please refer to the screenshot for reference. 

664
sumek
mahesh_gupta
mahesh_guptaNew Participant
asked in Community Q&A
Data Validation report post migration

Hi All, Greetings! We need to migrate data from Oracle to PostgresSQL using striim. In this case does striim provides data reconciliation report post loading the data in the target system. Regards, Mahesh

461
john
john
johnCommunity Manager
asked in Product Q&A
Striim vault with Google Secrets Manager not working

I created a Vault that integrates with Google Secrets Manager. As the documentation suggests, we use a service account key with ‘Secrets Accessor’ permissions.However we’re getting the below error 

791
swaritjoshipura
sumek
sumekKnown Participant
asked in Community Q&A
CDC Postgres UUID to SQL Servers uniqueidentifier

Hi all, I’m trying to set up a CDC from Postgres(GCP Cloud SQL if it makes any difference) of a table with a UUID column to a SQL Server table with uniqueidentifier column. The wizard says it’s not possible. I’ve tried mapping the tables manually, but all the rows end up being discarded. Is there any way to make it work? Similar migration in the opposite direction works. 

1335
sumek
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.

1093
igg-mario
john
johnCommunity Manager
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.

1851
S
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

1762
D
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?

1451
john
john.smith
john.smithNew Participant
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.

1611
S

Badge winners

Show all badges
Terms & ConditionsCookie settings