Very simple question . How can I migrate few tables from Oracle to couchbase without using a third party tool like Talend ? I was looking for couple of threads where somebody suggested to use GoldenGateAdapter whereas in other place suggested to use a undocumented open source java library to move t…

@manuel.hurtado - Dear Manuel , Need your help on your well written github auto data migration process outlined here : [image] GitHub - mahurtado/oracle2couchbase: Move data easily from Oracle to... Move data easily from Oracle to Couchbase database - mahurtado/oracle2couchbase …

@binh.le - Hi Binh , Need your help - When I am executing UPSERT with CURL for single document pull from Oracle to my CB Bucket using the Query tool on Web Console I am hitting below problem : Here my oracle exist on diff host while CB bucket exist in completely diff host . Is that a problem you se…

I would try running the curl statement from the command line on the CB query node. Does it work there?

Unfortunately Not . I have tried to execute that same as you said inside the POD node using below : and then UPSERT same issue . cbq -e http://localhost:8093/ -s “select * from test” -u Administrator -p password or cbq -e http://localhost:8091/ -s “select * from test” -u Administrator -p password …

The request is supposed to be sent to your Oracle server, not the Couchbase server. So you need to: Add the Oracle server IP to the request. http://<your oracle server ip here>:8080 Also follow the instructions to : Enable Oracle schema for Rest Services https://blog.couchbase.com/how-to-use-n…

Sorry I should be giving full snippets : , I understand that part … cbq -e http://localhost:8091 -u=Administrator -p=password cbq> UPSERT INTO test (key ndoc.doc_key,value ndoc) SELECT ndoc.doc_key, ndoc FROM CURL(“ http://oraclehost:8080/ords/oracleschema/_/sql ”, { “request”:“POST”,“header”:“Co…

[image] eldorado: CB forum not liking my word under open angle < and close angle > where I was trying to write oracleschema or Post as Pre-ormated text. Highlet the text and click the 6th button (lessthan+slash+gratethan)

Can you run the SELECT… from the Couchbase Workbench? SELECT ndoc.doc_key, ndoc FROM CURL("http://oraclehost:8080/ords/oracleschema/_/sql", { "request":"POST","header":"Content-Type: application/sql" , "data":"SELECT 'source' doc_type, 'source_id:' || ds.source_id doc_key, ds.* FROM source_dim ds" …

Oracle to Couchbase

Couchbase Server

eldorado August 16, 2019, 9:21pm 12

@binh.le - Sorry again I have lately edited and corrected and remove all open angle ‘<’ and close angles bracket ‘>’ so this is where I stand on current issue… your help is appreciated

Topic		Replies	Views
Migrating Oracle DB to Couchbase Couchbase Server	15	2937	November 23, 2020
Oracle2couchbase Java SDK	0	648	August 20, 2019
How to replicate data from couchbase to oracle Couchbase Server	4	4280	May 12, 2021
Oracle to couchbase real time sync using oracle Goldengate adaptor will it update the rev of the couchbase document created Mobile	4	3058	November 21, 2020
Data migration : is there a tool similar to Flyway or Liquibase for Couchbase? Java SDK java , n1ql	6	6652	April 27, 2023

Oracle to Couchbase

Related topics