Insert into SQL nonLawson table from CSV file

unknown

New to IPA. Simple process to read an CSV file and insert the records into a non Lawson SQL table. Tried different scenario's in IPD and so far unsuccessful. Can this even be done? Any examples would be appreciated.

unknown

Hi SteveJ,

There isn't any "magic" to doing a SQL insert in IPA. It is just a SQL transaction call to the server. However, there are many pieces that could be problematic:

Here are some things to check:
- Do you have the correct SQL drivers loaded on the designer (if running locally) and server (if running on the server)?
- Do you have a valid connection configured for the target server?
- Does the SQL user have the appropriate rights to perform an insert against that database/table?
- Are you are using the SQL Transaction node type rather than a SQL Query node type?
- Does your Landmark server have access to the remote server or is it blocked (firewall rules, etc)?

If all the above is OK, here are a couple of things to try:
- Are you able to perform a static INSERT into the target table using IPA with your configured connection and user?
- Are you able to do a static insert as that user within a "regular" SQL client as that user?
- You may also want to try creating a stored procedure on the SQL server to perform the insert and calling that instead. I've heard some folks have had better success with that approach.

Please provide more details about what you have set up and what result you are getting. Is it an error? No response? Something else?

Kelly