Dynamic data pipeline problems for help ~-CodePudding

Now I want to build a dynamic data pipeline
Is the source database and target database can be changed by variable mass
But when the start defining a data pipeline is not to choose good source database and target database horses
How to change?
Thank you master!

CodePudding user response:

http://blog.csdn.net/daixf_csdn

CodePudding user response:

Thank you very much!

CodePudding user response:

Dizzy, don't stick!

CodePudding user response:

Ceng dotted

CodePudding user response:

Ceng dotted ss

CodePudding user response:

Ceng points, too

CodePudding user response:

To see the
But, don't understand
Too complicated, -_ -!

Can you provide a simple point of dynamic data pipeline,
Just can change the source and the graveyard database
Data representation fixed,
Thank you again!

CodePudding user response:

Just can change the source and the graveyard database

Then modify the sqlca and new transaction object database!

CodePudding user response:

I was modified the sqlca, but an error
Because at the time of establishing data pipeline (I am using the new - database - datapipeline)
Select the source database and target database and table, and transport
The source and target database established at the time when I was sure the
There are other ways to build data pipeline horse?

CodePudding user response:

See corresponding Transaction SQLERRTEXT when something goes wrong,
Who said just go wrong, you guess,

CodePudding user response:

Hey hey...
Patience..

CodePudding user response:

Prompt error is the source database error
Because I made of panel data pipeline, at the beginning is to specify the source database
But now and use it every time you modify the sqlca, changed the source database

I want to know is, how to dynamically as a data pipeline, can change the source database and target database
Don't need to change the table name transfer,

CodePudding user response:

Sigh ~ `
I think I made it very clear,
Why no one back to
?

CodePudding user response:

I make is very clear!

CodePudding user response:

I ordered the edit data pipeline where the source is as follows:
The PIPELINE ( source_connect=maps, destination_connect=cs2002 , type=refresh, commit=100, errors=100, keyname="T_FILE")
SOURCE (name="T_FILE", the COLUMN (type=varchar, name="ID", dbtype="VARCHAR2 (5)", the key=yes, nulls_allowed=no)
The COLUMN (type=varchar, name="SYSTEM_ID" dbtype="VARCHAR2 (5)", nulls_allowed=no)
The COLUMN (type=varchar, name="ENAME," dbtype="VARCHAR2 (50)", nulls_allowed=no)
The COLUMN (type=varchar, name="CNAME," dbtype="VARCHAR2 (50)", nulls_allowed=no)
The COLUMN (type=varchar, name="AENAME," dbtype="VARCHAR2 (50)", nulls_allowed=yes)
The COLUMN (type=varchar, name="ACNAME," dbtype="VARCHAR2 (50)", nulls_allowed=yes)
The COLUMN (type=varchar, name="FILETYPE," dbtype="VARCHAR2 (1)", nulls_allowed=no)
The COLUMN (type=varchar, name="ISDEAL," dbtype="VARCHAR2 (1)", nulls_allowed=no)
The COLUMN (type=varchar, name="FIRSTFIELD_TYPE," dbtype="VARCHAR2 (1)", nulls_allowed=no)
The COLUMN (type=varchar, name="ISFILTER," dbtype="VARCHAR2 (1)", nulls_allowed=no))
RETRIEVE the statement (="PBSELECT (TABLE (NAME=" SWIBS. T_FILE ~ "~) COLUMN (NAME=~" SWIBS. T_FILE. ID ~ ") COLUMN (NAME=~ "SWIBS. T_FILE. SYSTEM_ID ~") COLUMN (NAME=~ "SWIBS. T_FILE. ENAME ~") COLUMN (NAME=~ "SWIBS. T_FILE. CNAME ~") COLUMN (NAME=~ "SWIBS. T_FILE. AENAME ~") COLUMN (NAME=~ "SWIBS. T_FILE. ACNAME ~") COLUMN (NAME=~ "SWIBS. T_FILE. FILETYPE ~") COLUMN (NAME=~ "SWIBS. T_FILE. ISDEAL ~") COLUMN (NAME=~ "SWIBS. T_FILE. FIRSTFIELD_TYPE ~") COLUMN (NAME=~ "SWIBS. T_FILE. ISFILTER ~")) ")
DESTINATION (name="CS2002 T_FILE", the COLUMN (type=varchar, name="ID", dbtype="VARCHAR2 (5)", the key=yes, nulls_allowed=no, initial_value="https://bbs.csdn.net/topics/spaces")
The COLUMN (type=varchar, name="SYSTEM_ID" dbtype="VARCHAR2 (5)", nulls_allowed=no, initial_value="https://bbs.csdn.net/topics/spaces")
The COLUMN (type=varchar, name="ENAME," dbtype="VARCHAR2 (50)", nulls_allowed=no, initial_value="https://bbs.csdn.net/topics/spaces")
The COLUMN (type=varchar, name="CNAME," dbtype="VARCHAR2 (500)", nulls_allowed=no, initial_value="https://bbs.csdn.net/topics/spaces")
The COLUMN (type=varchar, name="AENAME," dbtype="VARCHAR2 (50)", nulls_allowed=yes)
The COLUMN (type=varchar, name="ACNAME," dbtype="VARCHAR2 (50)", nulls_allowed=yes)
The COLUMN (type=varchar, name="FILETYPE," dbtype="VARCHAR2 (1)", nulls_allowed=no, initial_value="https://bbs.csdn.net/topics/spaces")
The COLUMN (type=varchar, name="ISDEAL," dbtype="VARCHAR2 (1)", nulls_allowed=no, initial_value="https://bbs.csdn.net/topics/spaces")
The COLUMN (type=varchar, name="FIRSTFIELD_TYPE," dbtype="VARCHAR2 (1)", nulls_allowed=no, initial_value="https://bbs.csdn.net/topics/spaces")
The COLUMN (type=varchar, name="ISFILTER," dbtype="VARCHAR2 (1)", nulls_allowed=no, initial_value="https://bbs.csdn.net/topics/spaces"))

When begin to create the data pipeline has to book the source and target database

Although later changed the transaction i_src, i_dst values, but doesn't work, will hold the source database error.

How to establish a data pipeline can be directly modified transaction i_src, i_dst values will change data pipeline of source and destination database

Thank you ~

CodePudding user response: