{"id":99972,"date":"2019-12-02T10:07:57","date_gmt":"2019-12-02T08:07:57","guid":{"rendered":"http:\/\/www.javacodegeeks.com\/?p=99972"},"modified":"2019-12-10T09:07:30","modified_gmt":"2019-12-10T07:07:30","slug":"extending-the-aws-ecosystem-with-universal-data-access","status":"publish","type":"post","link":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html","title":{"rendered":"Extending the AWS Ecosystem with Universal Data Access"},"content":{"rendered":"<p>Amazon Web Services (AWS) helps organizations host and manage their data processes, like building data visualizations and performing ETL tasks. At CData, we make it easy to connect AWS Services with heterogeneous business applications and distributed data stores to ultimately help businesses develop a more holistic analysis of their data.<\/p>\n<p>With CData&#8217;s comprehensive connectivity between AWS and 150+ SaaS, Big Data, and NoSQL enterprise data sources, you can:<\/p>\n<ul class=\"wp-block-list\">\n<li>Connect pure cloud analytics like Amazon QuickSight with real-time data from any application through&nbsp;<a href=\"https:\/\/www.cdata.com\/cloudhub?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\">CData Cloud Hub<\/a>, a cloud-to-cloud data access tool.<\/li>\n<li>Design automated data pipelines that sync data across applications and AWS services using&nbsp;<a href=\"https:\/\/www.cdata.com\/sync?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\">CData Sync<\/a>.<\/li>\n<li>Create serverless on-demand processes to move data between the cloud and any of the 150+ data sources we support using AWS Glue and our&nbsp;<a href=\"https:\/\/www.cdata.com\/jdbc?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\">JDBC Drivers<\/a>.<\/li>\n<\/ul>\n<p>This post briefly walks through the three processes above. For a deeper dive, follow the links to our related Knowledge Base articles.<\/p>\n<h2 class=\"wp-block-heading\">NetSuite Data in Amazon QuickSight through Cloud Hub<\/h2>\n<p>Connecting to and visualizing SaaS, big data, or NoSQL data in Cloud Hub can be done in 4 steps.<\/p>\n<h3 class=\"wp-block-heading\">1. Create a Virtual Database for NetSuite<\/h3>\n<p>In the MySQL client of your choice, connect to your Cloud Hub instance and create a new virtual database:<\/p>\n<pre class=\"brush:sql\">CREATE DATABASE netsuite_db\nDRIVER = \"NetSuite\",\nDBURL = \"User=email@domain.com;Password=*******;AccountId=XABC123456;\";\n<\/pre>\n<h3 class=\"wp-block-heading\">2. Connect to the CData Cloud Hub<\/h3>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-1-1024x636.png\" alt=\"\" class=\"wp-image-99973\" width=\"768\" height=\"477\" srcset=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-1-1024x636.png 1024w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-1-300x186.png 300w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-1-768x477.png 768w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-1.png 1276w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n<\/div>\n<h3 class=\"wp-block-heading\">3. Select Data to Import into SPICE<\/h3>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-2-1024x636.png\" alt=\"\" class=\"wp-image-99974\" width=\"768\" height=\"477\" srcset=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-2-1024x636.png 1024w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-2-300x186.png 300w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-2-768x477.png 768w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-2.png 1276w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n<\/div>\n<h3 class=\"wp-block-heading\">4. Build Visualizations and Dashboards<\/h3>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-3-1024x636.png\" alt=\"\" class=\"wp-image-99975\" width=\"768\" height=\"477\" srcset=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-3-1024x636.png 1024w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-3-300x186.png 300w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-3-768x477.png 768w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-3.png 1276w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n<\/div>\n<h4 class=\"wp-block-heading\">Read the Full Article<\/h4>\n<p>For a detailed walk-through of using the CData Cloud Hub to connect to live NetSuite data from Amazon QuickSight, read our&nbsp;<strong><a href=\"https:\/\/www.cdata.com\/kb\/tech\/netsuite-cloudhub-quicksight.rst?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\">Knowledge Base article<\/a><\/strong>.<div style=\"display:inline-block; margin: 15px 0;\"> <div id=\"adngin-JavaCodeGeeks_incontent_video-0\" style=\"display:inline-block;\"><\/div> <\/div><\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/www.cdata.com\/kb\/tech\/netsuite-cloudhub-quicksight.rst?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\"><img decoding=\"async\" width=\"248\" height=\"40\" src=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/button-1.png\" alt=\"\" class=\"wp-image-99976\"\/><\/a><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\">Replicate Dynamics CRM Data to Amazon Redshift<\/h2>\n<p>Easily replicate your Dynamics CRM Data to an Amazon Redshift instance with the CData Sync point-and-click interface.<\/p>\n<h3 class=\"wp-block-heading\">1. Connect to Dynamics CRM<\/h3>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-4-1024x613.png\" alt=\"\" class=\"wp-image-99977\" width=\"768\" height=\"460\" srcset=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-4-1024x613.png 1024w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-4-300x180.png 300w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-4-768x460.png 768w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-4.png 1276w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n<\/div>\n<h3 class=\"wp-block-heading\">2. Connect to the Redshift Database<\/h3>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-5-1024x613.png\" alt=\"\" class=\"wp-image-99978\" width=\"768\" height=\"460\" srcset=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-5-1024x613.png 1024w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-5-300x180.png 300w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-5-768x460.png 768w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-5.png 1276w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n<\/div>\n<h3 class=\"wp-block-heading\">3. Configure the Replication Job<\/h3>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-5-1-1024x613.png\" alt=\"\" class=\"wp-image-99979\" width=\"768\" height=\"460\" srcset=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-5-1-1024x613.png 1024w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-5-1-300x180.png 300w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-5-1-768x460.png 768w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-5-1.png 1276w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n<\/div>\n<p> Check out our&nbsp;<strong><a href=\"https:\/\/www.cdata.com\/kb\/tech\/kb\/tech\/dynamicscrm-sync-redshift.rst?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\">Knowledge Base article<\/a><\/strong>&nbsp;for a detailed look of using CData Sync to replicate Dynamics CRM data to an Amazon Redshift instance. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/www.cdata.com\/kb\/tech\/kb\/tech\/dynamicscrm-sync-redshift.rst?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\"><img decoding=\"async\" width=\"248\" height=\"40\" src=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/button-1-1.png\" alt=\"\" class=\"wp-image-99980\"\/><\/a><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\">Salesforce Data in AWS Glue<\/h2>\n<p>Follow the steps below to connect to your Salesforce data in AWS Glue jobs using CData JDBC Drivers.<\/p>\n<h3 class=\"wp-block-heading\">1. Upload the JDBC Driver to S3<\/h3>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-7-1024x660.png\" alt=\"1- AWS Ecosystem\" class=\"wp-image-99981\" width=\"768\" height=\"495\" srcset=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-7-1024x660.png 1024w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-7-300x193.png 300w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-7-768x495.png 768w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-7.png 1058w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n<\/div>\n<h3 class=\"wp-block-heading\">2. Configure the Glue Job<\/h3>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-8-1024x716.png\" alt=\"\" class=\"wp-image-99982\" width=\"768\" height=\"537\" srcset=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-8-1024x716.png 1024w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-8-300x210.png 300w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-8-768x537.png 768w, https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/20190819-cdata-amazon-8.png 1058w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n<\/div>\n<h3 class=\"wp-block-heading\">3. Write the Glue Script<\/h3>\n<pre class=\"brush:js\">...\n\n## Use the CData JDBC driver to read Salesforce data \n##   from the Account table into a DataFrame\n## Note the populated JDBC URL and driver class name\njdbc_url = \"jdbc:salesforce:\" + \n           \"RTK=5246...;\" + \n           \"User=username@domain.com;\" + \n           \"Password=******;\" + \n           \"SecurityToken=Your_Security_Token\";\nclass_name = \"cdata.jdbc.salesforce.SalesforceDriver\";\nsource_df = sparkSession.read.format(\"jdbc\")\n                         .option(\"url\",jdbc_url)\n                         .option(\"dbtable\",\"Account\")\n                         .option(\"driver\",class_name)\n                         .load()\n\n...\n<\/pre>\n<h3 class=\"wp-block-heading\">4. Run the Glue Job<\/h3>\n<p>With the script written, we are ready to run the Glue job. Click Run Job and wait for the extract\/load to complete. You can view the status of the job from the Jobs page in the AWS Glue Console.<\/p>\n<p>For a step-by-step explanation of connecting to Salesforce in AWS Glue jobs through JDBC Drivers hosted in Amazon S3, read our&nbsp;<strong><a href=\"https:\/\/www.cdata.com\/kb\/tech\/salesforce-jdbc-aws-glue.rst?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\">Knowledge Base article<\/a><\/strong>.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/www.cdata.com\/kb\/tech\/salesforce-jdbc-aws-glue.rst?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\"><img decoding=\"async\" width=\"248\" height=\"40\" src=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/button-1-2.png\" alt=\"\" class=\"wp-image-99983\"\/><\/a><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\">Make the Most of Amazon Web Services<\/h2>\n<p>With CData connectivity solutions you are getting&nbsp;<a href=\"https:\/\/www.cdata.com\/tech\/performance?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\">high-performance<\/a>&nbsp;client libraries and applications that help you maximize your investment in Amazon Web Services. Whether you use&nbsp;<a href=\"https:\/\/www.cdata.com\/cloudhub\/demo?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\">CData Cloud Hub<\/a>&nbsp;to see your data in Amazon QuickSight, upload&nbsp;<a href=\"https:\/\/www.cdata.com\/jdbc\/?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\">CData JDBC Drivers<\/a>&nbsp;to S3 to access live data from AWS Glue, or automate and customize your data replication with&nbsp;<a href=\"https:\/\/www.cdata.com\/sync\/?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\">CData Sync<\/a>, you will capitalize on the speed and utility of Amazon Web services. Download a free trial of any of our products to get started and reach out to our world-class&nbsp;<a href=\"https:\/\/www.cdata.com\/support\/submit.aspx?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\">Support Team<\/a>&nbsp;if you have any questions.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/www.cdata.com\/sync\/download\/?utm_source=jcg&amp;utm_medium=post&amp;utm_campaign=aws\"><img decoding=\"async\" width=\"202\" height=\"44\" src=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2019\/11\/button-1-5.png\" alt=\"\" class=\"wp-image-99994\"\/><\/a><\/figure>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Amazon Web Services (AWS) helps organizations host and manage their data processes, like building data visualizations and performing ETL tasks. At CData, we make it easy to connect AWS Services with heterogeneous business applications and distributed data stores to ultimately help businesses develop a more holistic analysis of their data. With CData&#8217;s comprehensive connectivity between &hellip;<\/p>\n","protected":false},"author":29565,"featured_media":112,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[758],"class_list":["post-99972","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-enterprise-java","tag-aws"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Extending the AWS Ecosystem with Universal Data Access - Java Code Geeks<\/title>\n<meta name=\"description\" content=\"Interested to learn about AWS Services? Check our article explaining how at CData, you can connect AWS Services with heterogeneous business applications\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Extending the AWS Ecosystem with Universal Data Access - Java Code Geeks\" \/>\n<meta property=\"og:description\" content=\"Interested to learn about AWS Services? Check our article explaining how at CData, you can connect AWS Services with heterogeneous business applications\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html\" \/>\n<meta property=\"og:site_name\" content=\"Java Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/javacodegeeks\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/cdatasoftware\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-02T08:07:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-10T07:07:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/enterprise-java-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"CData Software Inc.\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cdatasoftware\" \/>\n<meta name=\"twitter:site\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CData Software Inc.\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/12\\\/extending-the-aws-ecosystem-with-universal-data-access.html#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/12\\\/extending-the-aws-ecosystem-with-universal-data-access.html\"},\"author\":{\"name\":\"CData Software Inc.\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/person\\\/19c65bb5031586911b74c42be951e307\"},\"headline\":\"Extending the AWS Ecosystem with Universal Data Access\",\"datePublished\":\"2019-12-02T08:07:57+00:00\",\"dateModified\":\"2019-12-10T07:07:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/12\\\/extending-the-aws-ecosystem-with-universal-data-access.html\"},\"wordCount\":539,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/12\\\/extending-the-aws-ecosystem-with-universal-data-access.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2012\\\/10\\\/enterprise-java-logo.jpg\",\"keywords\":[\"AWS\"],\"articleSection\":[\"Enterprise Java\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/12\\\/extending-the-aws-ecosystem-with-universal-data-access.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/12\\\/extending-the-aws-ecosystem-with-universal-data-access.html\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/12\\\/extending-the-aws-ecosystem-with-universal-data-access.html\",\"name\":\"Extending the AWS Ecosystem with Universal Data Access - Java Code Geeks\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/12\\\/extending-the-aws-ecosystem-with-universal-data-access.html#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/12\\\/extending-the-aws-ecosystem-with-universal-data-access.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2012\\\/10\\\/enterprise-java-logo.jpg\",\"datePublished\":\"2019-12-02T08:07:57+00:00\",\"dateModified\":\"2019-12-10T07:07:30+00:00\",\"description\":\"Interested to learn about AWS Services? Check our article explaining how at CData, you can connect AWS Services with heterogeneous business applications\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/12\\\/extending-the-aws-ecosystem-with-universal-data-access.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/12\\\/extending-the-aws-ecosystem-with-universal-data-access.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/12\\\/extending-the-aws-ecosystem-with-universal-data-access.html#primaryimage\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2012\\\/10\\\/enterprise-java-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2012\\\/10\\\/enterprise-java-logo.jpg\",\"width\":150,\"height\":150,\"caption\":\"java-interview-questions-answers\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/12\\\/extending-the-aws-ecosystem-with-universal-data-access.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/category\\\/java\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Enterprise Java\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/category\\\/java\\\/enterprise-java\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Extending the AWS Ecosystem with Universal Data Access\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#website\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\",\"name\":\"Java Code Geeks\",\"description\":\"Java Developers Resource Center\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\"},\"alternateName\":\"JCG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.javacodegeeks.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/exelixis-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/javacodegeeks\",\"https:\\\/\\\/x.com\\\/javacodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/person\\\/19c65bb5031586911b74c42be951e307\",\"name\":\"CData Software Inc.\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2721fe9b0602c96f82ac3257c81aae932f175b04f339557cc678f89b417afc56?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2721fe9b0602c96f82ac3257c81aae932f175b04f339557cc678f89b417afc56?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2721fe9b0602c96f82ac3257c81aae932f175b04f339557cc678f89b417afc56?s=96&d=mm&r=g\",\"caption\":\"CData Software Inc.\"},\"description\":\"CData Software (www.cdata.com) is a leading provider of standards-based drivers and data access solutions for real-time integration with on-premise and SaaS applications, NoSQL, and Big Data. Our drivers are universally accessible, providing straightforward access to popular data technologies like JDBC, ODBC, ADO.NET, and OData. Our tools offer real-time integration from BI, ETL, Reporting, Analytics and custom Apps to more than 100+ data sources, including Big Data &amp; NoSQL databases, CRM, ERP, and Accounting packages.\",\"sameAs\":[\"http:\\\/\\\/www.cdata.com\",\"https:\\\/\\\/www.facebook.com\\\/cdatasoftware\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/cdatasoftware\",\"https:\\\/\\\/x.com\\\/cdatasoftware\"],\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/author\\\/cdata-software-inc\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Extending the AWS Ecosystem with Universal Data Access - Java Code Geeks","description":"Interested to learn about AWS Services? Check our article explaining how at CData, you can connect AWS Services with heterogeneous business applications","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html","og_locale":"en_US","og_type":"article","og_title":"Extending the AWS Ecosystem with Universal Data Access - Java Code Geeks","og_description":"Interested to learn about AWS Services? Check our article explaining how at CData, you can connect AWS Services with heterogeneous business applications","og_url":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html","og_site_name":"Java Code Geeks","article_publisher":"https:\/\/www.facebook.com\/javacodegeeks","article_author":"https:\/\/www.facebook.com\/cdatasoftware\/","article_published_time":"2019-12-02T08:07:57+00:00","article_modified_time":"2019-12-10T07:07:30+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/enterprise-java-logo.jpg","type":"image\/jpeg"}],"author":"CData Software Inc.","twitter_card":"summary_large_image","twitter_creator":"@cdatasoftware","twitter_site":"@javacodegeeks","twitter_misc":{"Written by":"CData Software Inc.","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html#article","isPartOf":{"@id":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html"},"author":{"name":"CData Software Inc.","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/person\/19c65bb5031586911b74c42be951e307"},"headline":"Extending the AWS Ecosystem with Universal Data Access","datePublished":"2019-12-02T08:07:57+00:00","dateModified":"2019-12-10T07:07:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html"},"wordCount":539,"commentCount":1,"publisher":{"@id":"https:\/\/www.javacodegeeks.com\/#organization"},"image":{"@id":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html#primaryimage"},"thumbnailUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/enterprise-java-logo.jpg","keywords":["AWS"],"articleSection":["Enterprise Java"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html","url":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html","name":"Extending the AWS Ecosystem with Universal Data Access - Java Code Geeks","isPartOf":{"@id":"https:\/\/www.javacodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html#primaryimage"},"image":{"@id":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html#primaryimage"},"thumbnailUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/enterprise-java-logo.jpg","datePublished":"2019-12-02T08:07:57+00:00","dateModified":"2019-12-10T07:07:30+00:00","description":"Interested to learn about AWS Services? Check our article explaining how at CData, you can connect AWS Services with heterogeneous business applications","breadcrumb":{"@id":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html#primaryimage","url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/enterprise-java-logo.jpg","contentUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/enterprise-java-logo.jpg","width":150,"height":150,"caption":"java-interview-questions-answers"},{"@type":"BreadcrumbList","@id":"https:\/\/www.javacodegeeks.com\/2019\/12\/extending-the-aws-ecosystem-with-universal-data-access.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.javacodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Java","item":"https:\/\/www.javacodegeeks.com\/category\/java"},{"@type":"ListItem","position":3,"name":"Enterprise Java","item":"https:\/\/www.javacodegeeks.com\/category\/java\/enterprise-java"},{"@type":"ListItem","position":4,"name":"Extending the AWS Ecosystem with Universal Data Access"}]},{"@type":"WebSite","@id":"https:\/\/www.javacodegeeks.com\/#website","url":"https:\/\/www.javacodegeeks.com\/","name":"Java Code Geeks","description":"Java Developers Resource Center","publisher":{"@id":"https:\/\/www.javacodegeeks.com\/#organization"},"alternateName":"JCG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.javacodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.javacodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/www.javacodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/javacodegeeks","https:\/\/x.com\/javacodegeeks"]},{"@type":"Person","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/person\/19c65bb5031586911b74c42be951e307","name":"CData Software Inc.","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/2721fe9b0602c96f82ac3257c81aae932f175b04f339557cc678f89b417afc56?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/2721fe9b0602c96f82ac3257c81aae932f175b04f339557cc678f89b417afc56?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2721fe9b0602c96f82ac3257c81aae932f175b04f339557cc678f89b417afc56?s=96&d=mm&r=g","caption":"CData Software Inc."},"description":"CData Software (www.cdata.com) is a leading provider of standards-based drivers and data access solutions for real-time integration with on-premise and SaaS applications, NoSQL, and Big Data. Our drivers are universally accessible, providing straightforward access to popular data technologies like JDBC, ODBC, ADO.NET, and OData. Our tools offer real-time integration from BI, ETL, Reporting, Analytics and custom Apps to more than 100+ data sources, including Big Data &amp; NoSQL databases, CRM, ERP, and Accounting packages.","sameAs":["http:\/\/www.cdata.com","https:\/\/www.facebook.com\/cdatasoftware\/","https:\/\/www.linkedin.com\/company\/cdatasoftware","https:\/\/x.com\/cdatasoftware"],"url":"https:\/\/www.javacodegeeks.com\/author\/cdata-software-inc"}]}},"_links":{"self":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/99972","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/users\/29565"}],"replies":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/comments?post=99972"}],"version-history":[{"count":0,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/99972\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/media\/112"}],"wp:attachment":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/media?parent=99972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/categories?post=99972"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/tags?post=99972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}