All geek questions in one place

What is the fastest way to pull data from a foreign database

I need to extract data from a single table stored in an MSSQL database. Then the data is stored in the staging table in AX, from where it is processed in accordance with business logic.

Performance is a key factor in this project.

Now I was exploring the possibilities of retrieving data from an MSSQL database with X ++ code and found the following blog:

Connecting to databases via X ++

Basically, there are various ways that can be used for this purpose:

  • ODBC - the ability to open a database
  • OLEDB - Linking and Embedding Objects
  • ADO - ActiveX Data Objects
  • Connection class

Now I was hoping that someone could give a contribution that is preferable and why (especially regarding performance).

.

+4
2

, , AX, ODBC, OLEDB ADO/.NET.

.NET( OleDB ), System.Data.SqlClient System.Data.OleDb, .NET. CIL, .

, , .

+7

/ Ax 2012.

+5

Source: https://habr.com/ru/post/1626836/

More articles:


All Articles