Connect to SQL server

rlgarcia06
rlgarcia06
in Integrations and extensibility

Good day

I have an SQL server as source of my data. What are my options to import this data to Anaplan?

 

Thank you!

Renier

Tagged:

Answers

  • jesse_wilson
    jesse_wilson

    Hi @rlgarcia06,

     

    Please review our integration options. Anaplan Connect, and the listed 3rd party ETL tools all have SQL database connectivity.

     

    Regards

  • rlgarcia06
    rlgarcia06

    Sorry for the confusion, the source data is from SQL Database. Can we use Anaplan Connect to automatically import data?

  • jesse_wilson
    jesse_wilson

    Hi,

     

    The above still applies, Anaplan Connect, and ETL tools can read from SQL databases. Anaplan UI cannot connect to a database, you must give a flat file if you're uploading directly to a model from the UI.

     

    Thanks,
    Jesse

  • rlgarcia06
    rlgarcia06

    Thanks Jesse. Can you give more details on how to use Anaplan Connect for importing data from SQL databases? Because what I can only see is how to import flat files from the server using Anaplan Connect. 

     

    Regards

    Renier 

  • jesse_wilson
    jesse_wilson

    Hi Renier,


    The Anaplan Connect guide provides documentation for connecting to a SQL database to extract data. It uses JDBC to connect to your database, and execute a query you define.

     

    Regards,

    Jesse

Categories