Welcome Dialog

Welcome to the Community!

We have a brand new look! Take a tour with us and explore the latest updates on Adobe Support Community.


Read data from Database within After Effect

New Here ,
Aug 17, 2021 Aug 17, 2021

Copy link to clipboard

Copied

Hello 

 

What I want to do is, read data "some words" dynamically from a database using MySQL and display it on screen. I want to know if this is possible in Adobe After Effects? And how do I connect if possible? Do I have to write a script where it can be written?

 

Thank you

TOPICS
How to, Import and export, Scripting

Views

22

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Enthusiast ,
Aug 17, 2021 Aug 17, 2021

Copy link to clipboard

Copied

It's definitely possible.  You would need to use Sockets to communicate via ExtendScript.  You can also use something like Templater from Dataclay to easily handle this, but you would need to create a small server that you point Templater to rather than a direct connection to the database.  See this support article for more information on how Templater communicates to an endpoint exposed by an API that you implement.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Aug 17, 2021 Aug 17, 2021

Copy link to clipboard

Copied

LATEST

You can build your own system with sockets as outlined in the docs

or even easier someone built a fairly simple to use library for making HTTP requests in ExtendScript.

Example Usage:

var data = $http({
method: 'GET',
url: 'http://example.com/data.json',
headers: {'Accept': 'application/json','Content-Type': 'application/json'}
});
alert(data.payload);


Unfortunately HTTPS is not supported FYI. If you need it, you may want to make a CEP panel instead.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines