Stack Overflow
Stack Overflow

Questions tagged [external-data-source]

51 questions
4
votes
0 answers

Implement KeyCloak Role Storage and Role Mapping over external Database

I have a requirement of implementing KeyCloak over external Database and should be able to CRUD users and roles and along with mapping/assigning them. I also able to develop CRUD Users using User Storage SPI, but was unable to find any content…
KNDheeraj
  • 834
  • 8
  • 23
3
votes
1 answer

SQL Azure - Create External Data Source: Location as a Parameter?

I'm attempting to create a SQL stored procedure that will create an External Data Source. The location is to be a parameter passed into the procedure (e.g. an azure storage account container). I can't get the Location variable to be accepted (as in…
B.Tullero
  • 95
  • 6
2
votes
1 answer

Why is External Table syntax different in SQL Server 2019 vs Azure SQL Database? `

I have to perform cross DB querying in SQL Server 2019 as well as Azure SQL. I am able to create External data source and external tables in both databases, however the syntax seem to be different. Can someone please guide me if there is one…
Shubham Garg
  • 21
  • 1
2
votes
1 answer

Loading CSV from Azure Data Lake (Gen 2) to Azure SQL Database

I have an Azure Data Lake Storage (Gen 2) account with several containers. I would like to import the salesorderdetail.csv file from the Sales container into an Azure SQL database. I've successfully built the same process using Azure Data Factory,…
MAK
  • 125
  • 2
  • 13
2
votes
0 answers

SQL Server 2016 errror Incorrect syntax near 'EXTERNAL'

I have two SQL Server 2016 VMs in Azure. I am trying to connect these two sql server instances using External datasource. I can safely connect the two instances from my local pc, remotely. While querying using external table/data source, I am…
user240141
1
vote
0 answers

Refresh Excel table connected to Visio Org Chart (insert rows)

I am having an issue with Visio Professional. I have successfully linked an Excel table as an external data source to the Visio Org Chart, when I alter a row in the Excel table and refresh the Visio Org Chart it successfully updates and displays the…
Minyun
  • 35
  • 4
1
vote
1 answer

How to integrate external data sources in a SOLID Principle

I've been using the SOLID Design Principles, in C# with Entity Framework for a while, and works great. Now I have a situation where I need to get data from an external Web API call. What's the best way or what approach should I take to integrate an…
bflow1
  • 49
  • 1
  • 9
1
vote
0 answers

Terraform External Data Source not working properly

I am using Terraform External Data Source to get a response from the Azure DevOps rest api (objectId of the branch to be used as further input to other scripts/actions). I'm calling a python script via the external data source resource as…
Arvind
  • 79
  • 1
  • 7
1
vote
0 answers

Azure Pipline issue- ExcelDataReader Not found used by Specflow External Data Package

I am using Specflow External Data for data input in my Specflow Tests. I have my .xsl file as a DataSource for the Feature files located in the same Feature Folder. It is running fine on my local machine but when integrated to Azure DevOps Pipeline,…
PriyadarshaniPPatil
  • 11
  • 2
1
vote
1 answer

Create external data source in Azure Synapse Analytics (Azure SQL Data warehouse) to Oracle

I am trying to create external data source in Azure Synapse Analytics (Azure SQL Data warehouse) to Oracle external database. I am using the following code in SSMS to do that: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'myPassword'; CREATE DATABASE…
Ani
  • 11
  • 3
1
vote
1 answer

Checking if date is overdue from text file

I have a text file that has users and then due dates. I would like to be able to read the due date which was initially input by the user and see if the date is overdue compared with the current date. Any help would be appreciated. Text file: User:…
NoobDev88
  • 23
  • 6
1
vote
2 answers

How to add math to your functions for writing to a text file

Could someone please help with how the correct way to add math to an already created function that writes output to a text file. The first task was to write the numbers to a output.txt file in values from lowest to highest, no matter the number or…
user12739323
1
vote
0 answers

Azure SQL Database build failure for External Data Sources and External Tables

I recently created an external data source and a few external data tables to query between Azure SQL Databases. This works successfully and I have used the results in PowerBI. I then attempted to pull the objects into my data project in Visual…
Russ Manning
  • 11
  • 1
1
vote
1 answer

Printing only specific words from .txt file - Python

Any help with the following question will be greatly appreciated. I have the following .txt file named DOB: Orville Wright 21 July 1988 Rogelio Holloway 13 September 1988 Marjorie Figueroa 9 October 1988 Debra Garner 7 February 1988 Tiffany Peters…
user12739323
0
votes
1 answer

Feed data from an external database directly into an array

I have a 4D database from which I need to periodically pull data using Excel and VBA. For now, the machine that I intend to run this on is similar to a Mac mini (Late 2014) on OS 10.13.6 and Excel for Mac 2011. I know, it is old, but it is what I…
Schrocks
  • 13
  • 4
1
2 3 4