python
Python: Load Data from MySQL
To connect to MySQL in Python, there are various approaches: JDBC driver - JayDeBeApi python wrapper package. Native python MySQL packages, for example, MySQL connector, etc. This article provides an example of using MySQL connector package to connect to MySQL. Python 3 MySQL server.
Python: Load Data from Hive
To load data from Hive in Python, there are several approaches: Use PySpark with Hive enabled to directly load data from Hive databases using Spark SQL: Read Data from Hive in Spark 1.x and 2.x . Use ODBC or JDBC Hive drivers. Cloudera has implemented ODBC drivers for Hive and ...
A Microsoft SharePoint list is a collection of data can be shared with team members or people who you give access to. It is commonly used to capture commonly maintained master data from manual inputs. This article summarizes steps to create a SharePoint list and then load the data in the list ...
Read and Write XML Files with Python
XML is a commonly used data exchange format in many applications and systems though JSON became more popular nowadays. Compared with JSON, XML supports schema (XSD) validation and can be easily transformed other formats using XSLT. XHTML is also a strict version of HTML that is XML based and used ...
Partition is the parallelism unit in a Kafka cluster. Partitions are replicated in Kafka cluster (cluster of brokers) for fault tolerant and throughput. This articles show you how to work with Kafka partitions using Python as programming language. Package kafka-python will be used in the ...
Apache Kafka is written with Scala. Thus, the most natural way is to use Scala (or Java) to call Kafka APIs, for example, Consumer APIs and Producer APIs. For Python developers, there are open source packages available that function similar as official Java clients. This article shows you ...
Pandas is commonly used by Python users to perform data operations. In many scenarios, the results need to be saved to a storage like Teradata. This article shows you how to do that easily using JayDeBeApi or sqlalchemy-teradata package. JayDeBeApi package and Teradata JDBC ...
Python: Load / Read Multiline CSV File
CSV is a common data format used in many applications. It's also a common task for data workers to read and parse CSV and then save it into another storage such as RDBMS (Teradata, SQL Server, MySQL). In my previous article PySpark Read Multiple Lines Records from CSV I demonstrated how to ...
Python JayDeBeApi module allows you to connect from Python to Teradata databases using Java JDBC drivers. In article Connect to Teradata database through Python , I showed how to use teradata package to connect to Teradata via Teradata ODBC driver. This article demos how to use this JayDeBeApi ...
Python: Read Data from SQLite via JDBC
To read data from SQLite database in Python, you can use the built-in sqlite3 package . Another approach is to use SQLite JDBC driver via JayDeBeApi python package. Download the JAR file from one of the online repositories: Maven Repository BitBucket or any other equivalent ...