2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Username : your_username@company.com
Password : Password
Profile Name : Sage Sage IntacctToDatabase

Code Block

<authentication>
<userName>username@yourcompany.com</userName>
<password>your_password</password>
<profile>IntacctToDatabase<<profile>Sage Sage IntacctToDatabase</profile>
</authentication>

...

A sample profile.xml file is shown below with configuration details of the adapters that are used for integration.


Code Block

<?xml version="1.0" encoding="UTF-8"?>

<!-- DBSync User Details -- >

<profile id="your_username@company.com" name="Sage Sage IntacctToDatabase" loglevel="ALL" email="" guid="0006FBC6">

<!-- Sage Sage Intacct Adapter Configuration -- >

<adapter name="Sage Sage Intacct" type="com.avankia.appmashups.adapter.intacct.Sage Sage Intacct.Sage Sage IntacctAdapter">
<property name="userid">username</property>
<property name="password" encrypted="true">XXXXXX</property>
<property name="senderid">avankia</property>
<property name="dtdversion">2.1</property>
<property name="hostUrl">www.intacctSage Sage Intacct.com</property>
<property name="companyid">company-DEV</property>
<property name="controlpassword">XXXXXXX</property>
</adapter>
<adapter name="ConsoleAdapter" type="com.avankia.appmashups.engine.conversion.adapters.ConsoleAdapter" />

<!-- Database Adapter Configuration  -- >

<adapter name="database" type="com.avankia.appmashups.engine.conversion.adapters.DatabaseAdapter">
<property name="password" encrypted="true">XXXXXX</property>
<property name="url">jdbc:sqlserver://localhost:1433;databaseName=Sage Sage Intacct</property>
<property name="autocommit">true</property>
<property name="driver">sqlserver</property>
<property name="dbname">intacct<>Sage Sage Intacct</property>
<property name="username">sa</property>
</adapter>
</profile>

...

The following section shows a Sample Java Code which can be used to make a REST-CALL. The highlighted section shows the modified parameters as per to your DBSync, Database and Sage Sage Intacct credentials.

Sample Java Code :

Code Block

package com.avankia.appmashups.rest;

import java.io.File;
import java.net.URLEncoder;
import org.apache.commons.io.FileUtils;

public class TestClient
{
public static void main(String[] args) throws Exception
{

String authenticationXML = "<authentication>" + "<userName>username@company.com</userName>" + "<password>password</password>" + "<profile>IntacctToDatabase<<profile>Sage Sage IntacctToDatabase</profile>" + "</authentication>";
String profileXML2="";
String profileXML = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>"\+

/*
Sage Sage Intacct Adapter Configuration
*/

"<profile id="localhost@avankia.com" name="INTACCTSage Sage Intacct" loglevel="ALL" email=""guid="01F6CCDC">"+
"<adapter name="Sage Sage Intacct" type="com.avankia.appmashups.adapter.intacct.Sage Sage Intacct.Sage Sage IntacctAdapter">"+
"<property name="userid">admin</property>"+ // Sage Sage Intacct UserId
"<property name="password" encrypted="true">XXXXXXXXX</property>"+ //Encrypted Sage Sage Intacct Password
"<property name="senderid">company</property>"+  // Sage Sage Intacct SenderId
"<property name="dtdversion">2.1</property>"+   //  Sage Sage Intacct DTD Version
"<property name="hostUrl">www.intacctSage Sage Intacct.com</property>"+  // Host URL
"<property name="companyid">Company-ID</property>"+  // Sage Sage Intacct Company Id
"<property name="controlpassword">YYYYYYYY</property>"\+ // Sage Sage Intacct Control Password
"</adapter>"+


/*
Database Adapter Configuration
*/

"<adapter name="database" type="com.avankia.appmashups.engine.conversion.adapters.DatabaseAdapter">"+
"<property name="password" encrypted="true">XXXXXXX</property>"\+ //Database Password
"<property name="url">jdbc:mysql://localhost:3306/yourdb</property>"+ // Database Connection String
"<property name="autocommit">true</property>"+
"<property name="driver">mysql</property>"+ // Database Driver
"<property name="dbname">mysql</property>"+
"<property name="username">root</property>"+  // Database User
"</adapter>"+
"</profile>";
\\
StringBuilder content = new StringBuilder();
content.append("authenticationXML=");
content.append(URLEncoder.encode(authenticationXML, "UTF-8"));
content.append("&");
content.append("profileXML=");
content.append(URLEncoder.encode(profileXML, "UTF-8"));
content.append("&");
content.append("payload=processdefinition_testpdl.xml");
String response = Http.post("http://localhost:8080/dbsync2/dbsyncrestservice.m", content.toString(), "application/x-www-form-urlencoded");
System.out.println("HTTP Response:\n"+response);
}
}

...