Follow my colleagues' discussions:
I have a task related to this topic and I want to share what I did, hopefully it will help someone.
How it look like:
$row[VALUE2]/$row[VALUE3] show up because I change the code to an non-existed database.
1/ Create a webpage that allowed user to input value/ choose value from a drop-down (populate data from a SQL database).
2/ Based on user input, when they click the "Transfer Information" button all the information will send to AE server and execute a specific job.
3/ Show the result (JOB's runID or Error message) which returned from AE Server.
- Automation Engine v12.1 and above (Active JCP/JWP)
- Database server: I'm using MSSQL 12
- Web hosting (PHP): In my case, I'm using XAMPP in Windows. So I need to install:
+ ODBC MSSQL client
+ Accessing SQL Server Databases with PHP:
Copy to C:\xampp\php\ext
++ Config the PHP.ini file:
I'm not a developer, so the code might look stupid and not clean =)
Please download the attachment for that.
+ AE Prompt-set variable:
+ Authorization: Basic ************=
I took this from Postman. To be honest, I still can't figure out how to send the NAME/DEPARTMENT with PASSWORD directly to AE server. Looking for some suggestion :)
- config.php: Connect to the database
Some reference links: