HomeForum
Welcome, Guest

Integration automation question
(1 viewing) (1) Guest
Data Warehousing and Data integration
  • Page:
  • 1
  • 2

TOPIC: Integration automation question

Integration automation question 7 months, 2 weeks ago #3981

  • john
  • OFFLINE
  • Junior Boarder
  • Posts: 23
  • Karma: -1
Looking at purchasing your software.

It looks like it does everything we need.
Can all functions be automated and executed at a scheduled time?
I assume so, but want to be sure.

thanks,
John

Re: Integration automation question 7 months, 2 weeks ago #3982

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
John

You can use enterprise version for automation

(Visual Importer ETl or Advanced ETL Processor)

Mike,
dbSL

Re: Integration automation question 7 months, 2 weeks ago #3984

  • john
  • OFFLINE
  • Junior Boarder
  • Posts: 23
  • Karma: -1
Hi Mike,

One last question. Can you call stored procedures in MySQL from your ETL tool? I need to be able to do some complicated data transformations and I will definitely need to use a coding language that has if-then-else/cursors/ for each, etc, etc. capabilities. Can your tool do something like that?

thanks

John

Re: Integration automation question 7 months, 1 week ago #3987

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Yes you can call stored procedures or execute sql scripts.

Mike

Re: Integration automation question 7 months, 1 week ago #3988

  • john
  • OFFLINE
  • Junior Boarder
  • Posts: 23
  • Karma: -1
Hi Mike

1) Does this software only work on Windows? If so, do you put it on the server and then remote desktop into it, or do you put an agent on your own desk top and use that? How does it work in this regard?

2) Do you have a trial software we can download to see how it works?

thanks

John

Re: Integration automation question 7 months, 1 week ago #3989

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
1) Does this software only work on Windows?

Only windows

If so, do you put it on the server and then remote desktop into it, or do you put an agent on your own desk top and use that?
How does it work in this regard?

Yes put it on the server than remote desctop on it

2) Do you have a trial software we can download to see how it works?

Everything is available for download from our website

www.etl-tools.com/etl-tools/advanced-etl...rprise/overview.html

thanks
Mike
  • Page:
  • 1
  • 2
Time to create page: 0.19 seconds

Testimonials

I had my first upload running within 10 minutes of installing Visual Importer ETL

Gene Kovacs,
Director of Technical Business Operations,
A2B

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top