ANAPLAN CONNECT - ISSUE WITH A MYSQL QUERY

New Contributor

ANAPLAN CONNECT - ISSUE WITH A MYSQL QUERY

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.

 

 

 

Message 1 of 3
2 REPLIES 2
New Contributor

Re: ANAPLAN CONNECT - ISSUE WITH A MYSQL QUERY

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

 

BR

Message 2 of 3
Highlighted
Expert

Re: ANAPLAN CONNECT - ISSUE WITH A MYSQL QUERY

Change the import data source settings in Anaplan to: UTF-8 character encoding TAB separated no delimiter header row=1 first data row=2
Message 3 of 3