ANAPLAN CONNECT - ISSUE WITH A MYSQL QUERY

egauche
egauche
in Integrations and extensibility

Hi all,

 

I'm trying to upload data from MySQL database.

To do that I have made a batch file (windows script).

 

In a first step, I have made a CSV file (fullfilled from a query exceuted in MySQL) and I have no issue to upload data using the script.

==> No issue to connect to ANAPLAN

==> All records have been uploaded

 

In a second step, I have updated  the script and used directly MySQL query to upload data.

==> No issue to connect to ANAPLAN and to MySQL Database

==> All records are found

==> But all columns of the query are concatenated into a single column

 

Have you already met this issue ? Can you help me ?

 

Many thanks.

Emmanuel.

 

 

 

Tagged:

Best Answer

  • ben_speight
    ben_speight
    Answer ✓
    Change the import data source settings in Anaplan to: UTF-8 character encoding TAB separated no delimiter header row=1 first data row=2

Answers

  • egauche
    egauche

    One precision, I'm using a JDBC connection and I have no issue connecting to data base.

     

    BR

Categories