in technology connectors we can use any type of profiles like all database,json,edi,csv,xml but in application connector it depends on connector's operation and it allows only json and xml profiles only.
why application connector allows only json and xml profiles? why not other profiles?
There is no functional difference. An application connector is targeted at one specific application (e.g. Salesforce or Netsuite). A technology connector, on the other hand, implements a specific "protocol" (e.g. HTTP, messaging, or database) and can talk to any application which communicates via that protocol.
Application connectors are designed to work with a specific application's API and therefore can perform certain conveniences to make it even easier to integrate with that application. For example application connectors often abstract certain default values, complicated login handshakes or session management, pagination, splitting and batching, and more.
Technology connectors provide a generic means to exchange data via a given protocol. You will use them to integrate with applications or data sources that don't have a specific application connector. Because you're working a lower "protocol" level, you will need to be more familiar with the technical aspects of the API.
If an application connector exists for your application, you should use it. If not, use a technology connector, or alternatively consider developing your own custom connector with the Connector SDK.
Retrieving data ...