Is there an error in the "Create Entity-Backed Records" tutorial? (

Hi Mark,
This error is indicative of a connectivity issue between the data store you have created and the database instance. Have you created your CDTs and then the data store that references them and gone through the Verify and then Save and Create steps to ensure that the tables are created in your data base correctly and that Appian can communicate with your data base instance? (This would be step 3 in the Create Entity-Backed Records tutorial.) You may also reference the documentation on Data Stores for any additional information you may need. forum.appian.com/.../Data_Stores

I've tried to follow the instructions in the tutorial, but keep running into a problem setting the "id" field as "the primary key and set to generate value". I don't see a way to do this in Appian Designer--seems like I can't do that until I create the Data Store, at which point I auto-create the tables. Then, I have to go into mySQL and change the key from "A_ID" to "id", and that appears to be where the problem occurs.

I'm sorry, I'm not a DBA nor am I a developer. I'm just trying to use software that reportedly requires no programming.

Instructions for creating a primary key here:
forum.appian.com/.../Defining_a_Custom_Data_Type

Basically you just want to export the XSD before you publish it, add the markup indicated to create a Primary Key, save the XSD, and import. Then when you publish to a data store, Appian will take care of all the column names etc for you. You don't need to worry about changing any columns by hand if you follow these steps.

Once you've created your data store, it's best to verify that it is configured correctly (e.g. by creating a simple query rule or Write to Data Store node) to eliminate issues before you dive into the new Records functionality.

I'm trying that now, but when creating the Data Store, I get the
no matching tables" found when verifying. So, I Save and Publish as indicated, and get the "Unable to automaticaly create tables" message. Do I need to go down the "DDL Script" route, and if so, how does that work? Keep in mind that last time I programmed was 25 years ago in COBOL.

If you've already created tables to match your CDT, try dropping them (in MySQL) and re-publishing your data store. "no matching tables" just means "no perfectly matching tables" -- there might be an existing table with a conflict.

That fixed it--I was able to continue through the tutorial. Thank you!!

Great, glad you got it working!