![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 95%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,859 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
The reason you can't see the activities table in the Oracle Eloqua Connector could be due to the connector’s limitations in accessing certain types of objects or tables directly. The Oracle Eloqua Connector in Azure Data Factory may have restricted visibility into specific system tables like "activities," or its available API endpoints might not support direct access to certain resources.
Using the Eloqua Bulk API is a good alternative, as it’s designed for exporting large datasets efficiently, including complex data like activities. You could use a custom approach with a Web Activity in ADF to authenticate with the Bulk API and a Copy Activity to load the data into Snowflake, bypassing the need for direct connector access to the activities table. This setup would involve creating a Bulk API job for data extraction, polling the job status until it’s complete, and then copying the resulting data files.