Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

How data accessed from Databases

Highlighted
5 - Atom

There is a requirement to access data from transactional database say oracle. Which has millions of record and is used by applications 24*7 in high load. When we create a task in alteryx to get data from such DB, will the data be acquired using DB client connection or will it use Oracle data logs to get the data from backside of oracle. How that works in Alteryx? Could anyone help understand?

Highlighted
8 - Asteroid

You can directly create a DB connection and write your queries to get data from the database.

Highlighted
5 - Atom

This will add additional load to my existing usage where 24*7 clients are accessing it in high volumes. Is it possible to use oracle transaction logs to retrieve data from it. Rather creating client connection and copy data through front end.

Labels