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.

Accepted answers

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

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

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

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385