SQL Insertion of Transactions

 

Software Integration Using SQL Insertion

Deprecated feature.

When not to use SQL insertion
Most of the time - we no longer recommend this feature for new users.
With the increasing power of CPUs, the speed of file imports rivals that of SQL Insertion.

Excel and csv file imports (based on an i9, 32 GB RAM computer):
60,000 records imported in 45 seconds. An ACH file of 240,000 was created in 2 minutes.
The downsides of SQL Insertion (complexity of setup, feature subset and bypass of QA controls) no longer outweigh the speed benefits.

ACH Universal's SQL Insertion feature is bundled within the Software Integration Kit (SIK).

This feature enables you to insert transactions directly into a table within the ACH Universal SQL database.

While the majority of the Software Integration Kit (SIK) is 'Point and Click', this feature requires you to initiate the 'push' the transactions from your database into ours. This is an advanced feature and requires a strong working knowledge of SQL commands.

Setup

Select 'SQL Insertion' on the main screen or our Software Integration Kit (below)

Select the SQL Insertion options - in essence, you're telling ACH Universal what types of data to expect.

Testing

Need a test SQL script to populate the table? Tip: Start SQL Server Management Studio and click on 'New Query' (make sure that you're in the right database). Then copy the script below.

INSERT into tblHoldingGLIntegration (tblHoldingGLIntegration.Amount, tblHoldingGLIntegration.Description, tblHoldingGLIntegration.Text1, tblHoldingGLIntegration.ACH_Account, tblHoldingGLIntegration.ACH_Routing_ABA, tblHoldingGLIntegration.ACH_CheckingorSavings, tblHoldingGLIntegration.Class_3_Letters, tblHoldingGLIntegration.Date) VALUES ('123.45', 'ABC Company', 'ABC01', '88888888','063000047', '0', 'CCD', '12/31/2013')

Tip: No valid records when using your data? - Remember that the software will filter out invalid ABA numbers. Make sure that you use valid ABA numbers in testing.

For a step-by-step checklist, see our SQL Insertion Help.