HomeForum
Welcome, Guest

ETL Evaulation Questions
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: ETL Evaulation Questions

ETL Evaulation Questions 1 year, 1 month ago #2331

  • Samuel
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
Hi.

I am looking more into the Advanced ETL Processor Pro and Advanced ETL Processor Ent and have some additional questions which I couldn't find answers to in the manuals and on the forums. Could you please help with the questions listed below?

1) Can Metadata be extracted to external data source or reports?
2) Can the Solution interact with Web Services as a data source and data target?
3)Can the ETL execute a stored procedure within a workflow and pass the results to a workflow as a data source?
4)Can it maintain fully functional PRODUTION and Disaster Recovery server environments?
5)Is there ease in promotion from development to TEST and PRODUCTION
6) Can jobs can be called by an external program (we are currently using TIDAL to call some of our processes)?
7) Can the Solution validate data source schemas?
8)Does the solution have open scripting capability (e.g. user defined functions and transformations)?

Sam

Re: ETL Evaulation Questions 1 year, 1 month ago #2332

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
Sam

Thank you for the interest in out software

The best way to prove that our software can do what you want is to email us couple of examples of what you are trying to achieve and we will email you back working examples with guide how to use them

1) Can Metadata be extracted to external data source or reports?

I am confused what do you mean by metadata.
We can extract a lot of data from various data sources

2) Can the Solution interact with Web Services as a data source and data target?

Can you provide us with example please

3)Can the ETL execute a stored procedure within a workflow and pass the results to a workflow as a data source?

It can

4)Can it maintain fully functional PRODUCTION and Disaster Recovery server environments?

You can easily backup and restore entire repository or separate projects

5)Is there ease in promotion from development to TEST and PRODUCTION

You can easily backup and restore entire repository or separate projects

6) Can jobs can be called by an external program (we are currently using TIDAL to call some of our processes)?

Yes you can call it from a command line

7) Can the Solution validate data source schemas?

There are more than 190 validation functions

8)Does the solution have open scripting capability (e.g. user defined functions and transformations)?

Yes, you can write your own scripts

Best regards,
Mike,
  • Page:
  • 1
Time to create page: 0.15 seconds

Testimonials

“DBSL has proved to be a robust and versatile solution that we continue to integrate with different aspects of our business.”

Bob Carter,
IT Consultant

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