Azure - ODBC - PowerBi

Eklon Eleuterio 1

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!"

Saurabh Sharma 23,816 Reputation points Microsoft Employee

2021-10-07T18:45:33.127+00:00

Hi @Eklon Eleuterio ,

Thanks for using Microsoft Q&A !!
For ODBC Source to work you need to configure SHIR on your on-premise server or a VM as IR is not going to work for establishing an ODBC connection. Also, you need to make sure the ODBC driver is 64-bit. Please refer to the documentation for details.
Please let me know if you have any questions.

Thanks
Saurabh
Eklon Eleuterio 1 Reputation point

2021-10-07T18:55:20.643+00:00

Hi Saurabh,

I appreciate your reply.

But it still not clear for me.

I want to use Azure services to keep the data online and available to be consumed in dashboards; but to do it, do I need an on-premises or VM machine? It sounds really weird to me.

There is easiest ways to do it as some simple script with python + docker to generate this file without the need of a machine.

Am I in the right direction?

Thank you!

1 answer

Saurabh Sharma 23,816 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
Please sign in to rate this answer.

1 person found this answer helpful.
Eklon Eleuterio 1 Reputation point

2021-10-07T19:53:06.927+00:00

Hi @Saurabh Sharma !

Our Netsuite data is on cloud also. But the only way to extract it is using ODBC, JDBC or Ado.Net.

One of these three connector works best with Azure structure?

The data need to be moved periodically. In most cases the refresh will happen once at month. I'm trying to avoid the costs of a VM just to update these data.

Thank you !!

Saurabh Sharma 23,816 Reputation points Microsoft Employee

2021-10-18T19:35:47.927+00:00

Hi @Eklon Eleuterio ,

sorry but I have not used any these adapters to work on a NetSuite data so unable to provide my inputs on your ask.
Also, if there are not existing infrastructure which you can use to create a SHIR then going through the VM route looks like the only option.

Thanks
Saurabh

Saurabh Sharma 23,816 Reputation points Microsoft Employee

2021-11-03T17:40:26.557+00:00

Hi @Eklon Eleuterio ,

We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Saurabh

Eklon Eleuterio 1 Reputation point

2021-11-10T01:16:40.763+00:00

Hi @Saurabh Sharma !

I appreciate all your help and support.

I will use the ODBC into a Ubuntu Docker image. And then run a python script that will export the CSV and save it in blob storage.
I guess that this is the best and economical way to do it.

thank you !!

Saurabh Sharma 23,816 Reputation points Microsoft Employee

2021-11-12T18:57:15.65+00:00

Hi @Eklon Eleuterio ,

Sure. Thank you.

Thanks
Saurabh
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure - ODBC - PowerBi

1 answer

Your answer