Azure - ODBC - PowerBi

Eklon Eleuterio 1 Reputation point
2021-10-06T17:44:03.52+00:00

Hi guys! I have a ODBC DataSource from Netsuite and I'll use it to refresh data into PowerBI.
In order to keep the data online, I'm developing the Azure Cloud Infrastructure using Terraform.

So, all the data came from Netsuite ODBC and thru data factory, these data will be access by PowerBI via Blob Storage.

But I'm not able to configure a ODBC connection inside a Data Factory, whitout the need of an on-premises server or a VM .

Don't we have a way to get and publish this data without a VM or a local server?

Thank you!"

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,612 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,122 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Saurabh Sharma 23,791 Reputation points Microsoft Employee
    2021-10-07T19:05:50.433+00:00

    Hi @Eklon Eleuterio ,
    Is your Netsuite data is on on-premise server ? Then you can install the SHIR on your on-prem machine instead of creating a new VM. Also, as you want to move data from NetSuite to Azure Blobs on regular basis you need to keep SHIR up and running for data transfer to take place. In case moving data is a one time activity then you can de-provision the VM's once the data movement from NetSuite to Blob is completed. Also, if you are able to move the data using Python+Docker to Azure blobs then you could probably go that route instead of creating additional resources to achieve the same.

    Thanks
    Saurabh

    1 person found this answer helpful.