sql tutorial for beginners,sql server tutorial,sql tutorial pdf,sql tutorials

8.3 revises data conduit

The data pipeline that our hope checks some moment to had been built — the PIPELINE1 that says to just be built for example — have a few modification jobs.How to do?The pushbutton of data conduit palette that clicks POWER BAR to go up,From PIPELINE 1 of the choice in list casing,Click OK pushbutton next,Opened this data pipeline again.

We click the SQL palette pushbutton that a moment ago had introduced,Fill in source data add a watch to list (graph 8-9) .

Graph 8-9

Exit source data to compile position next,Click ” affirmatory ” pushbutton affirms update,The system hints whether we save a moment ago modification,Choose ” be ” ,Shut data plumber to make a division.Finished what logarithm occupies conduit PIPELINE 1 to revise so.

8 .2 builds data pipeline

It is above POWER BAR,Have button of palette of conduit of a data (graph 8-1) .

Graph 8-1

We click this pushbutton.What appear subsequently is dialog box of data conduit choice (graph 8-2) .

Graph 8-2

Inside the list casing of the dialog box enumerate all has defined data conduit in the library file in pitch on.We hope to build pipeline of a data,The NEW pushbutton in clicking a dialog box,Enter dialog box of NEW DATA PIPELINE (graph 8-3) .

Graph 8-3

We saw list in casing of group of DATA SOURCE source of four kinds of data:QUICK SELECT, SQL SELECT, QUERY, STORED PROCEDURE.

In casing of group of DATABASE CONNECTION,We can choose source data library and purpose database.To the left SOURCE of source data library chooses in list casing,In DESTINATION of database of purpose of the choice in the list casing of right,The OK pushbutton that clicks a dialog box next,Dialog box of QUICK SELECT appeared,This is the choice in the data source option that is because of us in front is QUICK SELECT.The 8-4 that be like a graph.

Graph 8-4

[1] [2] issues one page

8 .Brief introduction of conduit of 1 data

Use POWER BUILDER when,We use a main functional data pipeline via regular meeting (PIPELINE) .It was offerred to the user between database interior, database, the way that data duplicates quickly between DBMS even.Say simply,One service data conduit is a source data library perhaps goes among a watch that the data in many watches inputs purpose database.The process of this duplicate data calls a count to enter data according to conduit fill.