Connecting MS-SQL or Oracle Database to Salesforce Using Bizdata Universal API
User Guide: Configuring Source as MS-SQL Database or Oracle Database using Bizdata Universal API and Target as Salesforce
This user guide provides step-by-step instructions on how to configure the source in Bizdata Universal API for connecting to either an MS-SQL Database or an Oracle Database and Target as Sales Force. By following this guide, you will be able to establish a connection and retrieve data from your chosen source database using the Bizdata Universal API and Send the data to the Target.
Data Source :
Step 1:
· In the Data Source page, Select the source type as API
Step 2:
· Now select the “Bizdata Universal API” as your product
Step 3:
· Select “MS-SQL Database (Version: 1.0) (Method: POST)” as your business object, if using Oracle then select the business object as “Oracle Database (Version: 1.0) (Method: POST)”
Step 4:
· Once the business object is selected, all the pre-requisites are loaded. Now, select the Authorization and do the following steps:
· Give the username and password for accessing the Bizdata universal API (For username and password connect with the Bizdata support team.)
The above mentioned username and password should be passed in the format shown below inside the Request Token Endpoint Body.
{"username":"xxxxxx","password":"xxxxxxxxxxxx"}
Step 5:
· Now, select the Body header. Configure the JSON data using following steps
Configuration Keys:
- jdbc_string: This key represents the JDBC connection string used to connect to the SQL Server database. The connection string has the following format: jdbc:sqlserver://{{host_ip}}:{{port_number}};databaseName={{schema_name}};encrypt=true;trustServerCertificate=true;
- {{host_ip}}: Replace this with the IP address or hostname of the SQL Server machine.
- {{port_number}}: Replace this with the port number on which SQL Server is listening.
- {{schema_name}}: Replace this with the name of the database schema or catalog you want to connect to.
Note: The "encrypt=true;trustServerCertificate=true;" part of the connection string enables SSL encryption for secure communication with the SQL Server. If your SQL Server is not configured for SSL encryption, you can remove this part from the connection string.
- jdbc_path: This key represents the path to the JDBC driver file on your system. It should point to the location where you have stored the "mssql-jdbc-10.2.0.jre8.jar" driver file. Ensure that the path is correctly specified to enable the application to load the JDBC driver.
- jdbc_driver: This key specifies the fully qualified class name of the JDBC driver for SQL Server. In this case, the value is "com.microsoft.sqlserver.jdbc.SQLServerDriver". It is important to have the correct driver class name to ensure that the JDBC driver is properly loaded and registered with the Java application.
- username: This key represents the username or login credentials required to access the SQL Server database. Replace the placeholder "{{Username}}" with the actual username or login name associated with your SQL Server database.
- password: This key represents the password associated with the provided username or login credentials. Replace the placeholder "{{Password}}" with the actual password associated with your SQL Server database.
- query: This key represents the SQL query that you want to execute on the database. In this example, the query is set to "Select * from tablename". Replace "tablename" with the actual name of the table or the desired SQL query that you want to execute.
Data Operations :
· According to the business needs Operations can be applied, For more information on operations you can visit the Bizdata Help page.
Data Target :
Step 1:
· Select Target Type as “API”
Step 2:
· Select the Target Name as “Salesforce”
Step 3:
· According to the business requirements select the business object
Step 4:
Once the business object is selected all the pre-requisites are loaded, if needed changes can be made to all the headers given.
Step 5: