SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Transfer data between two odbc sources?

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Transfer data between two odbc sources?
Author Message
Henrik Ingvarsson



Joined: 15 Aug 2003
Posts: 11

Post Transfer data between two odbc sources? Reply with quote

Hello!

I want to transfer data between one odbc source to another, and also i want to specify what data that should be transferred via sql. Is there a way to do this in 24x7?

Thanks!

/Henrik

Fri Aug 15, 2003 12:00 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7966

Post Re: Transfer data between two odbc sources? Reply with quote

Yes, it is doable. Please see DatabasePipe topic in the help.

You can also try DatabaseExport and DatabaseImport combination.

: Hello!

: I want to transfer data between one odbc source to another, and also i want
: to specify what data that should be transferred via sql. Is there a way to
: do this in 24x7?

: Thanks!

: /Henrik

Fri Aug 15, 2003 2:56 pm View user's profile Send private message
Henrik Ingvarsson



Joined: 15 Aug 2003
Posts: 11

Post Re: Transfer data between two odbc sources? Reply with quote

Ok, the DatabasePipe method works, but I still have some problems with duplicates.

My problem is that I have a program which generates a logfile (csv format). I want 24x7 to transfer this logfile to a mysql-database on a 24 hour basis. When this job runs i don't want it to import the whole csv-file all over again, but only the records whose id is above the last record in the database... Understand?

I've tried playing with the SQL statement in the databasepipe code, but no luck so far, just a bunch of error messages.

Have a tip for how I should avoid duplicates?

Thanks!

/Henrik

: Yes, it is doable. Please see DatabasePipe topic in the help.

: You can also try DatabaseExport and DatabaseImport combination.

Mon Aug 18, 2003 9:09 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7966

Post Re: Transfer data between two odbc sources? Reply with quote

What you can do to do is run DatabaseRetrieve and find out last used id.
Then copy part of your file starting with a new id into a new (temp) file and load that file instead of the original file.

Or you can load the entire file into a temp table and than execute INSERT..SELECT statement in the database to copy portion of thta temp table into the main one.

This all very doable. 24x7 supports a number of file operations for working with text files.

: Ok, the DatabasePipe method works, but I still have some problems with
: duplicates.

: My problem is that I have a program which generates a logfile (csv format). I
: want 24x7 to transfer this logfile to a mysql-database on a 24 hour basis.
: When this job runs i don't want it to import the whole csv-file all over
: again, but only the records whose id is above the last record in the
: database... Understand?

: I've tried playing with the SQL statement in the databasepipe code, but no
: luck so far, just a bunch of error messages.

: Have a tip for how I should avoid duplicates?

: Thanks!

: /Henrik

Mon Aug 18, 2003 1:29 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.