2,141 questions
1
vote
0
answers
29
views
Azure ODATA Source supporting compression
I‘m using an Azure Data Factory with an ODATA source from an external system. While everything works fine, I noticed the slow performance. So I checked this with postman and spotted immediately, that ...
1
vote
2
answers
69
views
Oracle ADF how to pass dynamic values into JS inside <af:resource type="javascript">
In Oracle ADF I am having
<af:resource type="javascript">
var chatSettings = {
url: "google.com",
id: "test"
}
function init(){
...
}
</af:resource>
<...
0
votes
0
answers
38
views
Adf Faces components are not rendering in Design View
In Oracle JDeveloper 12.2.1.4.0, ADF Faces components are not rendering in Design View. The page only displays component names instead of their UI structure. However, when running the application (Run)...
0
votes
1
answer
32
views
ADF Process XML
I get a response as xml formatted string from some web activity in ADF
<Transactions>
<Transaction
xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">
<...
0
votes
0
answers
64
views
Populate View Objects Programmatically
I am new to ADF and using JDeveloper 12.2.1.4.0.
I have the following use case.
I have a view object DepartmentVo defined on departments table(DepartmentEO) and have the REST API's exposed on it.
The ...
0
votes
0
answers
31
views
errror "Failed to access the data source." with all REST API URLs
https://drive.google.com/file/d/1CFMONqqhEk9jp-HwQLBzs_MuKrNhKfEl/view?usp=drive_link
I am working in Oracle ADF and attempting to configure a REST API for my application. However, every time I try to ...
1
vote
0
answers
69
views
how to get multi selected row values from a table of fusion screen using sandbox page composer
We have a requirement from Oracle fusion process requisition screen, when user selects the multiple rows from search results of table in process requisition screen. we need requisition number values ...
0
votes
1
answer
188
views
Azure Data Factory - SharePoint List connection issue
I'm connecting ADF to sharepoint site to collect data from multiple sharepoint lists.
Connector is working perfectly fine - ADF can get data from 2 lists stored on this sharepoint but one of them is ...
0
votes
1
answer
126
views
How to run SCOPE scripts in ADF with C# nuget
Looking at the documentation I see no example of how to run this script against ADLS instance; is there an example of what activity type etc. should be used for this functionality?
0
votes
0
answers
69
views
Unable to identify the errors in the SQL query
I am using this query in my ADF pipeline:
{@if(
equals(pipeline().parameters.IsUpsert,false),pipeline().parameters.SourceSQL,
if(
equals(pipeline().parameters....
0
votes
0
answers
143
views
Run GraphQL query in ADF dataflow
I am trying to create an ADF dataflow to extract data from API using GraphQL query. It has nested structures, and I believe copy activity does not support nested structures.
I tried using dataflow, ...
0
votes
0
answers
52
views
adf copy data tool - mongo db filtering
I have a collection in Mongo called 'collectionX'. I want to query whole data, except I want to filter out by event_date that is after July 1st (event, creationdate - unix milisecond timestamp). ...
2
votes
1
answer
394
views
ADF/Databricks : The table is not delta format
Getting error, when trying to copy data from CSV (Azure Blob) to Databricks Delta table. Using ADF Copy activity, Blob Storage as Source, Databricks Delta Lake as Sink. Getting error that the table is ...
0
votes
1
answer
161
views
Azure Data Factory, cant use Excel Dataset with Wildcard
My Problem:
I have a Data Lake Gen 2 Storage Account with an import directory which contains .xlsx files.
Storage Account
Now im trying to create a Dataset pointing to this directory. The Dir will ...
0
votes
1
answer
118
views
ADF Compare list from sql query to getMetaData output
I have a SQL table that contains the columns FileNamePrefix and TableName. I have files in blob storage that begin with the FileNamePrefix with some datetime in the name:
SQL table:
FileNamePrefix ...
1
vote
1
answer
252
views
Azure ADF: Losing Value of Pipeline Variable when re-running an Activity
In ADF, I have a demo pipeline with three activities and one pipeline variable called parentRunId:
pipeline variable
The first activity is a "Set Variable" activity and generates a UUID for ...
0
votes
1
answer
240
views
dynamic conversion of Decimal(38,18)data type that converts from default decimal datatype in ADF
ADF copy activity by default converts decimal datatype to decimal(38,18) , how can I overcome it to use original datatype decimal as source for multiple tables dynamically with different schemas for ...
0
votes
1
answer
161
views
How to parametrise the Data flow source 1 and source 2 in the same SQL DB but two different tables
I am building a Data flow pipeline which will call control flow pipeline.
The solution I am trying to achieve is to implement the Fuzzy logic for two master table to find relevant matching.
As show on ...
1
vote
0
answers
32
views
Issue in af:showDetailItem under panelAccordion component not getting the label after migrating source code from 12.2.1.3 to 12.2.1.4 J developer
Problem Description
Our code is running in 12.2.1.3.0 Jdeveloper and now deployed upgraded version on the 12.2.1.4.0 weblogic server
due to this we faced issue in af:showDetailItem under ...
0
votes
1
answer
465
views
Azure Data Factory Copy Data HTTP source zip file and sink as azure blob storage, asking to create two copy activities to work around it
I am getting this error message when trying to copy data from a HTTP source and my sink destination is an azure blob storage
I have a simple setup. I am visting the URL anonymously as I do not require ...
0
votes
1
answer
177
views
How to Open a JEE, STRUTS, and Oracle ADF Project Without .jws or .jpr Files in Oracle JDeveloper Studio?
Good afternoon,
I've encountered a challenge with a project handed to me. It's structured with JEE, STRUTS, and Oracle ADF. Initially, I attempted to work with it in IntelliJ. However, upon reviewing ...
0
votes
1
answer
136
views
How to verify the given node exists and read the value from azure data factory
I have a lookup where I am performing a query to get the employee_no
SELECT employee_no FROM HRS.EMPLOYEE_MASTER WHERE SOC_SEC_NO = '@{variables('FE_SoSecNo')}' this might return the data as follows
{
...
0
votes
0
answers
114
views
used query is not supported in odbc connector: Received this error while running through ADF - Database is Snowflake
Query is insert statement along with with as and select statement. It was running good previously but suddenly in production it errored out with this message. Couldn't find the reason behind it
There ...
0
votes
1
answer
592
views
Synapse/ADF Pipeline to Make HTTP API Request for every record in a database table
I have a table with 120,000 records in it. This will be my source table.
For each record in the table, I want to send a request to a REST API and then make a stored procedure call. There are reasons ...
0
votes
1
answer
1k
views
How to pass Variables return value in adf pipelines
In child pipeline1 I passed if condition in that true statement variable 1 is executed and in false statement variable2 is executed.
Now in ChildPipeline2 parameter I am passing value is
@or(activity('...