Question

Importing Data from SQL database and API Keys

  • 26 March 2024
  • 2 replies
  • 38 views

Im working with company sales data,i have many brands sales data ,I want to conect my each brand’s sales from Point of sales which is stored as API as well as data from SQL database in to amplitude.And I want to create dashboard from this sales data and want them to be automatically updated (My data refresh on daily basis)


2 replies

Userlevel 7
Badge +10

HI @Thalbish N K 

When you say sales data, is this stored in a traditional BI format or in an event format with a user entity attached?

If it’s a traditional BI way, then Amplitude isn’t the right tool to visualize such data and there are other better data viz tools out there.

Are there any data transformation or manipulation steps required during the import process to ensure compatibility or consistency with your application's data model?

Reply