locked
How to import a remote SQL database with Reader module? RRS feed

  • Question

  • Hello!

    I have a rational sql database and I want to import some data from the database with reader module. Do I have to create a data warehouse in portal.azure first for that or I directly can read data using user name password of the database? 

    Tuesday, March 22, 2016 12:13 PM

Answers

  • There are 2 (and soon to be 3) ways to do this:

    1. Create SQL Azure Database, and import your data there first. Then use a Reader module to read it.

    2. Create an Azure IaaS VM with SQL Server installed, import your data there. Then use a Reader module to read it.

    3. We are going to enable on-prem SQL read access soon. You will then be able to create a gateway on a local Windows box, and connect the Reader module directly to that gateway, and read your local SQL database.

    Wednesday, March 23, 2016 7:51 PM

All replies